I've looked around a bit and not found what I'm looking for, so here goes...

For each Contact record I can have several phone numbers. The Phones are in their own related table and shown in a portal window on the Contact layout.

What I want to do is allow one and only one of the Phone numbers for each Contact to be marked as "Main", thus making it unique in that portal for that Contact record.

If I were doing this in MySQL I'd index the combination of "Main" and "ID", making the combination unique, but I don't see how to do this in FMP. I tried working it by creating a new field that combined those two fields, but I can't make a calculation unique (or can't see how to).

Any suggestions, solutions, ideas?

Thanks,

Nelson

Why not store the primary key for the related phone record in a field in the contact record. You can then have a TO from Contact::fkMainPhoneID to pkPhoneID.

On the portal itself where it displays all the related phone numbers for the contact, you can have the row a button where it basically sets the Contact::fkMainPhoneID field with current portal row record's PhoneID.

Seems very similar to this.

John and Comment,

That was it exactly. Comment, the example you pointed to worked perfectly to accomplish what I was after.

Thanks