AnsweredAssumed Answered

How do I add a record to a join table through a portal?

Question asked by hogfoo on May 28, 2016
Latest reply on May 29, 2016 by hogfoo

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:


Contacts Table

ContactID (pk)

Contact Name


Type Table

TypeID (pk)

Type Name (customer, vendor, contractor, etc.)


ContactType Table (join table for Contacts and Type)

ContactTypeID (pk)

ContactID (fk)

TypeID (fk)


Here's a screenshot of the relationships.


Screen Shot 2016-05-28 at 2.09.21 PM.png


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?


Many thanks!