Jump to content

sum() in relation


Magnus
 Share

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

Recommended Posts

  • Newbies

Hi,

I have two files, A and B. In A I have a portal to B with a relation for a group of records (one group is 7 records, monday to sunday).

In B I have a time count for each member of the group (day of the week). In addition to this I have a summary field looking like this... sum(self_relation::time) that sums up the times for the members in the group.

But when I'm in file A with all the groupmembers listed in my portal, and I subtract or add time in one of the rows, the summary field does not update.

If I change to show another group and then change back again, it recalculates. But not when I change any of the values that the summary field is based on.

Any ideas someone??

Cheers,

Magnus

(I'm using FMP 5.5 on XP)

Link to comment
Share on other sites

Sorry,

just noticed you are using FMP 5

You will not be able to view my file.

Here is the outline of the file:

make relationship from parent to child,

call it PAR~Child (Allow creation)

use match fields...

PARENT_FILE: parent_primary_match_field

to

CHILD_FILE: parent_foreign_match_field

TABLE/FILE_A: Parent

parent_primary_match_field = auto enter serial number

clc_child_sum = Sum(PAR~Child::child_total)

TABLE/FILE_B: Child

parent_foreign_match_field

child_total

Does all that make sense? I have not used FMP 5 in so long I'm rusty.

Let me know if you have any questions.

take care!

Link to comment
Share on other sites

  • Newbies

Hi,

You're the best :P-)

I just put in a calculation field in parent file A, with sum(relation_to_child::time) and it works like a charm :-)

I can see that you are using FMP8 advanced. I've been thinking of upgrading my business system to FMP8 and FMP8 server, but haven't had the guts since I read about a lot of performance problems when FMP7 was released. Any comments on that?

I have FMP7 and 8 inhouse but haven't started to use it yet. Any 'as-long-as-you-think-about-this' when upgrading?

Cheers,

Magnus

Link to comment
Share on other sites

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