Updating many-to-many relationship through portals
Hi, I'm new to FileMaker and having trouble with my layouts.
I have two tables, 'Person' and 'Role', that share a many-to-many relationship. Each record in 'Person' has a 'Name' and a 'PersonID'. Each record in 'Role' has a 'Title' and a 'RoleID'.
I created an intermediate table, 'PeoplesRoles'. Each record in 'PeoplesRoles' has two fields, 'PersonID' and 'RoleID', each used as a relationship to their respective table. These relationships are configured to allow creation of records in 'PeoplesRoles'.
In the layout for 'Person' I created a portal to 'PersonsRoles' which shows 'PersonsRoles::RoleID' and 'Role::Title'.
I can create a new row in the portal by entering a 'PersonsRoles::RoleID' into a blank row, but that requires the user to know an arbitrary value.
What I can't figure out is how to allow a user to select a value from a value-list containing values from 'Role::Title' to add a row to the portal.