Hi all I might have a new project and there ...

[Jorge_Santos]

Hi all

I might have a new project and there is (for now) only one thing i need to know for SURE!

I need to know that i can prevent duplicates “on the fly” in the following scenario.

i select a “supplier” (ref table) and next i insert (manually) a invoice “number / text-number”. So can i prevent or warn the user that invoice already exists for that supplier?

This “record” of an invoice goes into a diferent table that the supplier table…

thanks in advance!!! Jorge

[Jorge_Santos]

Hi…

Or at least prevent the user from saving this new record…

Jorge

[Deep_Foundation]

@Jorge_Santos Use a valid if formula to see if the record already exists.