Jump to content
Sign in to follow this  
abelson

Relookup from Calculation Field

Recommended Posts

Using FM Pro 8.5. I have a file sorted on a specific number field. The number of times each number appears in this field is determined by a Summary calculation (= Count of) followed by a Calculation field (Unstored, = GetSummary). The individual numbers are in the "Body" section of the layout. The count is in the "Sub-summary" of the layout. As such, the count appears after last time the specific number is displayed. This works perfectly. The issue comes when another file performs Relookup of the number being counted and the corresponding count. The counted number is not picked up. Any ideas? I am new at Version 8.5. This works great in Filemaker 2.1 (real old version, but produces the desired results).

Share this post


Link to post
Share on other sites

FMP 2.1 was flat file.

I'd suggest that you revisit the whole data structure of the system and do it relationally. I'll bet your need to summarise, count and Re-lookup will magically disappear.

Share this post


Link to post
Share on other sites

I tried to restructure the entire data structure using relationships instead of relookups. The result is the same in as the "Count" as described in my initial posting does not appear in the file looking it up.

When I attempt to remove the check in the "Storage Option" on the count field from the prompt "Do not store the calculation result -- recalculate as needed", Filemaker displays an alert indicating that the "summary field can not be stored or indexed because it references a related field, summary field, and unstored calculation field, or a field with a global storage".

It is true that that field references a Summary field, but I believe this lack of allowing the storing of the number is the cause of the lookup and relationship functions not working.

Any help will really be appreciated.

Share this post


Link to post
Share on other sites

It seems my discription is camouflaging the real issue.

FM 8.5 will not allow a calculation field to be saved because the calculation references a summary field. As a result, neither the Relookup nor Relationship functions will get the calculated value into another file.

Would appreciate some advice on how to get the calculated value transferred.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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