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

(Jorge Santos) #1

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) #2

Hi…

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

Jorge

(Deep Foundations) #3

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