How do you compute the totals for Workmanship and Material Usage?
If you use a calculation field, named cWorkmanshipCost, in products defined as:
Sum ( Workmanship::Cost )
Then you can include Products::cWorkmanshipCost in the portal row and it should show the total of the WorkManShip::Cost field for that Product--even though the calculation is an unstored calculation field.
lets assume that this is the way that i named the fields, it is can be shown only on the layout of products.
but when i try to pull data from Products or Materials or Workmanships tables i cannot get any data even if it is on individual portal (on invoice layout which assigned to Invoices table)
i Added an explanation for my question in the attachment
What I'm talking about is your layout design and how it is based on the data model that you have defined.
From what I see, if you put Products::cWorkmanshipCost into the portal row of a portal to Invoice Items located on an Invoices based layout, it should show the correct sub total.
I try to only add portal of Products and it is not showing anything
Try a portal to Invoice Items and then add fields from Products to the Invoice Items portal. What you have will show no records in the portal unless you have related records in Invoice ITems that link to both the current invoices record and to products records.
thanks a lot
it works, i didnt allow to create and delete on that table from the other table, and also i didnt assigned the right details from that field, but now it is work perfectly