Is there any way that you can check if a record exists using field events (blur)? I would like to check if an invoice number exists as i enter it.
I have searched everywhere and used ChatGTP but cannot find any code that does not give an error.
I currently use "before record added" event to do this and it works fine, it just seems ridiculous that one has to go through the whole process of entering all the data only to find that the record exists at the end..
Any help on this would be GREATLY appreciated.
Regards,
Leon.