Prevent duplicate entry in multiple fields
FMP 11 Advanced.
I hope this makes sense.
I have 3 fields, fleld 1, field 2 and field 3. While entering data (radio program code #'s) into any of the 3 fields, if the data being entered already exists on another record in the "2 remaining fields", I would like a warning to be displayed and give the user the option to contue or not.
Thanks for any help.