Hello! First post here.
I'm new to FMP. Apologies in advance for what I suspect is a very basic question.
I'm working to create a simple contact management app. One thing I want to track is one or more types for each contact. This would seem so simple, but I'm stymied! I've set things up as follows:
Type Name (customer, vendor, contractor, etc.)
ContactType Table (join table for Contacts and Type)
Here's a screenshot of the relationships.
I want to have a way, on my Contacts layout, to associate multiple types with a given contact. I've been trying to have a portal with a dropdown showing the type name that, when selected, would update the join table with a new record linking the contact and the type. Can anyone offer some insight here?