Jump to content

Summary on relational records?


This topic is 7306 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7306 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.