AnsweredAssumed Answered

cross linking tables from within a portal row

Question asked by b24mike on Oct 1, 2014
Latest reply on Oct 1, 2014 by philmodjunk

Title

cross linking tables from within a portal row

Post

I'm a new FileMaker user.  I'm working on a World War II database that has mission, aircraft, and personnel tables.  Through a series of portals I am able to identify a particular individual on a specific airplane on any given mission.  What I would like to do is to display the information from the personnel table if I choose an individual from the right portal in the attached image.

For example, if I choose the first name in the portal row - Costain, Phillip M (pilot of 41-29149) - I would like to see his entry in the personnel table (shown in the lower image).  Can I do this via a script or do is there some other mechanism to achieve what I want?

Latest_Query.jpg

Outcomes