Summary on relational records?

[mikeytt]

I hope someone can point me in the right direction because i am going mad here.

I am working on a database for entering invoices. Each invoice (record) has an ID and fields for entering job codes and price, and then the total is shown at the bottom. So typical records would look like this:

-----

ID: X1

CODE PRICE

c 100

d 200

a 100

c 50

c 50

TOTAL : 500

----

ID: X2

CODE PRICE

c 100

d 200

c 20

b 50

TOTAL: 380

------

There are 2 db files. The master one holds each "invoice" and ID and shows the codes and prices in a portal (as shown above) from the related file.

What i need to do, on the layout above (master file), is show the total for one of the specific codes, EG for C - as you see that on each invoice there may be more than one. For example, invoice X1 C total would be 200.

I have now reached the point where i have thought about this too much and can't rationally think the process through anymore. Can anyone help. Much appreciated.

BASIC EXAMPLE FILES ATTACHED IN ZIP FILE

Version: Developer v6

Version: Developer v6

Example.zip

[CyborgSam]

Easy way:

In DATA, make a calculation called A.Price: If( code="A", price, 0).

In Master, define the Total for A calculation as: Sum(TEST::A.Price)

[jimbol46]

I have used the Troi number plug in when summary fields has brought FMP to its knees regarding multiple summary fields to another file.

it worked rather nice.