portal join tables
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.