Thanks in advance for any help or assistance you are willing to provide.
I'm working in FMP 12 and I would like to prevent entering duplicate student records by checking the uniqueness of a combination of the contents of multiple fields. For instance, when creating a new student record I would like to check the "Date Of Birth" and "Last 4 of SSN" fields of the new record against all existing records, rejecting the new record if the same combination is already present. Is there a way to accomplish this? Thanks again for your help!