work-a-round for summarizing from dynamic relashionship

[xtrim]

Hi,

The situation is the following:

DB A

*****

Field 1 - unsorted calc

Field 2 - unsorted calc

DB B

*****

Field 3 - portal match

The relationship is from DB_A(field 1) to DB_B(field 3) and named "DB_A_B"

Field 2 = count(DB_A_B::Field 3)

I need to be able to summarize field2..but it is not possible because it is a dynamic relationship (Field 1 is unsorted as it uses a global field in its calculation).

Creating a value list is also not possible for the same reason.

Any suggestion of how a summary can be accomplished?

[xtrim]

The version is FMP6....

[comment]

Summarizing an unstored calculation field may be slow, but it should work.

[xtrim]

How ? it wont let me even to choose this field for summarizing....

[comment]

Let me see if I understand this correctly:

File: PARENT

ParentID

File: CHILD

ChildID

ParentID

Value

Relationship from PARENT to CHILD:

PARENT::ParentID = CHILD::ParentID

File: PARENT

cCount = Count ( CHILD::Value )

Now you should have no problems defining a summary field in PARENT =

Total of cCount

[xtrim]

If the PARENT:ParentID is a calculated field that uses a global field then It is not working...

[comment]

It works for me - see atttached (I don't have ver.6 - open these two together).

summarize_unstored.zip

[xtrim]

:oops:

My mistake was that the calculated field was a "text" result, while it should be "number"...

Veteran...thank you so much for your patience...

Even after 5 years one can make silly mistakes...