AnsweredAssumed Answered

portals within portals

Question asked by AdamReed on Sep 9, 2011
Latest reply on Sep 16, 2011 by AdamReed

Title

portals within portals

Post

I would like to list mulitple expenses for multiple clients (related to the same project) on the same layout.

 

I have the following structure:

table:expenses

table:author

table:book

table: contract

table:payment

(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:

 

Tom

- $50 International Postage

- $35 IRS fee

 

Beth

- $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,

Adam

Outcomes