help..add data from portal files that share values

[gatti]

Alrighty, this is the situation...

I have a "clients.fp5" database and an "invoice.fp5" database. The client database shows a "portal" of each invoice that was created and linked by "client code". Now the thing is...certain invoices are to billed under a shared "contract code".

This "invoice.fp5" database uses a number field in regards to the "total billing price" and a number based "contract code" field that is to be used only when an invoice is to be billed under a shared bill. I plan on adding an additional database called "contracts" and have it as a portal in the "clients.fp5" database.

What I need to do is add the "total billing price" of the INVOICE records that specifically share/contain the same "contract code." Can someone help me and shed some light on the formula that I'd use?

[-Queue-]

It sounds like you just need to create a relationship based on contract code and a calculation to Sum(relationship::amount).

[gatti]

I'm not sure i understand. That thing is that I only want records that have a specific field number that match another databases field to be added. Perhaps if you can go into more detail that'll help out so much.

oooo. never mind. i got it now. thanks again.