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!