If it helps, I have a Contract table, then a PO table, then an invoice table. I have figured out on the PO table how to get add Invoice Record to show up. I believe my next step is to be able to sum all the various PO amounts that get entered for this PO. I have no idea how to sum, in one table, the associated records in another table.
Qrew LegendIF you have a relationships, then go to that relationship and on the left side it will let you make a summary field.
It looks like you relationship is this
Contracts < POs < Invoices.
In Quickbase shorthand that means
One Contract has many POs. One PO has many Invoices.
So make a summary field on the Relationship between POs and Invoices to get the Total Invoice value up to POs.
Then make a summary field on the relationship between Contracts and POs to get the total of the Total Invoice value up to Contracts.
OK then. Looks like summary field is the new term of the day for me. I will look it up. Thanks, Mark.
