AnsweredAssumed Answered

Updating many-to-many relationship through portals

Question asked by nathankruser on Jan 27, 2011
Latest reply on Jan 27, 2011 by philmodjunk

Title

Updating many-to-many relationship through portals

Post

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.

Outcomes