Jump to content

Summary Field & Related File


Senator
 Share

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

Recommended Posts

  • Newbies

Can somebody help me please, I'm going crazy.

I have recently upgraded to V7 and find that a summary field is not giving me the correct result.

I am working with two database files and the summary field (from the master file) is returning the value for one record only rather than the group of records. The summary field is placed on a layout in the related file.

I did not have this problem in version 5.5 and can't fathem why it would change.

Any comments would be greatly appreciated.

FileMaker Version: 7

Platform: Windows XP

Link to comment
Share on other sites

Hmm, strange.

Could you exact describe in which table you created the summary field and on which layout you placed the summary field? What is the relation between the two tables?

I just created a small demo with two tables: mother (which just one key: pk)

and a second table children (with a primary key: pk and foreign key: fk_motherid, a number field amount, and a summary field sumamount which is the total of amoutn. I created a relation between these two tables.

On the layout based on the mother table, I placed the summary field. These shows me the total of the related records.

Koen

Link to comment
Share on other sites

This topic is 6492 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
 Share

×
×
  • Create New...

Important Information

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