AnsweredAssumed Answered

Relating records three tables away

Question asked by aklobby on Nov 26, 2011
Latest reply on Nov 29, 2011 by aklobby


Relating records three tables away


I have a database that has three parent tables joined by child tables. I would like to see information from a parent record in another parent record that is separated by one parent and two join tables. Is this possible? 


group=parent        joined by group assignment        people in group = parent     joined by activity sponsors      activity= parent


I want to see information from the group table on the activity table. I can easily display the information I want to see in a portal within the group table. I am hoping to combine information from the two tables into one letter I send out. 

I am using Filemaker Pro 11

Any help would be greatly appreciated.