Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

  • Newbies
Posted

Hi All,

I am having difficulty in creating a summary total of data in a related table.

1st Table (Comparison DB) contains the field "Site", "Machine Type", "Gross Revenue"

2nd Table (2002) contains the same fields but has hundreds of records because at any one site there can be multiple of the same machine type.

The relationship uses "Site" & "Machine Type"

The 1st table will only contain one unique record for each site and then machine type but needs to summarise the gross revenue from table 2 by machine type. This summary field needs to be placed in a report on table 1 (Comparison DB) but extract the data from table 2.

Is this possible ?

Hope somebody understands. It is quite difficult to explain.

Thanx

Posted

If I have truly understood you, try so.

Creat getsummary field in second table by "Site&" & "Machin Type"

Sort your recors for getting the value of this field

Create relation from second table to first.

Then by script put data from second table to first using relation.

This is one of ways.

There are other ways to do it using export or import.

This topic is 7255 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.