portals within portals
I would like to list mulitple expenses for multiple clients (related to the same project) on the same layout.
I have the following structure:
(All tables have a primary id field.)
I've established the following relationships through their primary ids:
expenses and author
author and book
book and contract
contract and payment
I am displaying multiple authors on the payment layout through a portal. This works fine. The difficulty is also displaying the related expenses in another portal or portals (in the case of more than one author). So I'd like it to look like:
- $50 International Postage
- $35 IRS fee
- $36.82 Dining
- $14.00 Transportation
That sort of thing. I'd then like to be able to total the respective clients' expenses and add them up on that layout in calculated fields.
I am a relative beginning with filemaker, and would be grateful to be pointed in the right direction. Please let me know if more information is necessary, but I expect my question is fairly general?
Thanks very much,