sum() in relation

[Magnus]

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)

[Dr. Evil]

Hello,

I have had the same problem with summery fields not updating.

In this case I believe a calculation field summing the total will work for you.

I have attached a sample file using this clc(sum) field.

relationship_sum.fp7.zip

[Dr. Evil]

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!

[Magnus]

Hi,

You're the best -)

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