Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How to subtotal a join table through a portal.


obydesign
 Share

Recommended Posts

I am setting up an invoice database. I have a line item join table to display all ordered items on our invoice. The problem is that i cant figure out how to get a subtotal of all the individual items because all the individual items are separate records in the join table. Any help would be greatly appreciated.

Link to comment
Share on other sites

Assuming I understand your question correctly, you can do it one of two ways.

 

1. On a join table layout, use a "find records" script using the invoice number to search the records (no portal involved).

 

2. Create an invoice layout and place a join table portal on the layout. Make a new Invoice table global field for the invoice number and relate it to the invoice number of the join table.

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use