Greetings,
What is the best way to channel information from a grandchild record
to a parent record?
Situation:
Three tables: Parent, Child, GrandChild.
Two fields in each table: NameLast and NameFirst.
Based on a single field 'NameLast', e.g., "Pelto", I wish to see the
'NameFirst' of all children in one portal of the Parent file and of
all grand-children in another portal in the Parent file.
The first portal, NameFirst of all "Pelto" children records is easy
enough. A simple portal with a relationship based on "Pelto" as a
NameLast. And I could establish a similar relationship between Parent
and GrandChild, but I'm wondering if there is a way to channel the
data through the Child table into the Parent. Does such a capability
exist in FMP10?
Regards,
Chuck
