AnsweredAssumed Answered

portal join tables

Question asked by NancyHarris on Aug 18, 2015
Latest reply on Aug 18, 2015 by philmodjunk

Title

portal join tables

Post

I am very new to FMP and am building a database with three tables. One table has a set of events, the second table has a set of people (participants), and the third has the event id and the person id (basically shows which people attend which events). 

On the layout for the event, I have a tab in which I want to put a portal that will display the list of people attending the event and which can be used to add or delete participants. I have relationships among the three tables. How can I include data from two tables (the one linking the event and participant and the one with participant information)? I've hunted through the documentation, but am not finding it. 

Thanks in advance. 

Outcomes