AnsweredAssumed Answered

Establishing a Primary Record

Question asked by CraigRozelle on Nov 27, 2011
Latest reply on Nov 28, 2011 by DavidJondreau


Establishing a Primary Record


I have two tables: (1) a "contact" table and (2) a "phone number" table.

The "phone number" table has a "phone number" field and a "primary" field.

The contact table has a form with a portal displaying the "phone number table"

My question is: how do I allow for only one record to be the primary phone number for each contact? I am currently using two radio buttons in the "primary" field--"primary" and "other". If I select "primary", I would like Filemaker to change all the others to "Other".

Any suggestions would be most appreciated!