Parent, child, grandchild related portals on the same layout
Could someone please steer me to an answer to a relationship/portal problem that has been bugging me for a few weeks?
Having looked in the various books and Filemaker videos I still cannot figure the best way to arrange the structure of my solution.
I am building an advertisement booking system for our monthly magazines.
We sell advertisements to Customers, and the advertisements are held of in Bookings. Advertisements can be booked for just one month, OR 3, 6, 9 or 12 months.
So, we have Customers (parents), Bookings (children) and the individual Advertisements (grandchildren).
I am hoping someone can suggest how to do all this on the same layout. So that when viewing a Customer, we can view that Customer's Bookings (in a portal), then choose a Booking and automatically see that Booking's Advertisements (only that Booking's adverts.) in another portal.