AnsweredAssumed Answered

Can you validate multiple fields?

Question asked by BillisSaved on Jun 28, 2013
Latest reply on Jul 3, 2013 by Stephen Huston

Hey all,

 

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!

 

God bless,

Bill

Outcomes