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.