Portal showing fields from different tables?
Using FMP10, MAC OSX 10.5.7
For a theatre database,
I have a parent table People, and a Child table Casts with a join table Shows
The People table has fields> pk_ContactID, FirstName, LastName, email
The Show table has fields >pk_ShowID, ShowTitle, OpenDate, CloseDate, ShowDay, ShowTime
The Cast Table has >fk_ShowID, fk_ContactID, role/position,
I would like to be able to have a portal on the People table's tab that will pull from the three tables and show me for each person,
ShowTitle Role/Position, OpenDate, CloseDate, Showday, ShowTime
It seems like this should be simple but I'm having no luck because when I try to build the portal from the Cast Table, it doesn't allow me to bring in the show day/date/time info from the Show Table.
Any help suggested - I'm fairly new to Filemaker so please be gentle!
Actually your Cast table is the join table between People and Show.
From a People layout, place a portal that refers to Cast. Instead of the fields Cast::fk_ShowID and Cast::fk_ContactID, select the fields from the Show table you list in bold face and this should work for you.