Jump to content

Summarizing a Repeating Field


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

Recommended Posts

Is there a way to create a field that compiles entries from a repeating field? I am using a repeating field to track companies I am working with on a particular project. Entries in the field range from Zero to one or two, or up to as many as 15 or more. Accomodating this field on my layouts requires a separate layout, but it would be useful if I could create a field to feature on my primary layout for quick reference that summarized the results of the repeating field, like the following:

[Company A; Company B; Company C; etc.]

This seems like it should be pretty simple, but is beyond may current capabilities. Any help would be appreciated.

Thanks,

John

Link to comment
Share on other sites

Your response is very much appreciated, but I am not sure how it is helping me. The values that I would be using in the repeating field are coming from a seperate file "Companies." My problem is that the space required for the repeating field does not fit on my primary page, and it would be beneficial to be able to see those entries in some condensed form on the primary page. It seems to me that I should be able to create a field that takes the values from the repeating field for a particular record and show them with a seperator between values. Does that clarify what I'm trying to accomplish?

Thanks,

John

Edited by Guest
Link to comment
Share on other sites

Your response is very much appreciated, but I am not sure how it is helping me. The values that I would be using in the repeating field are coming from a seperate file "Companies." My problem is that the space required for the repeating field does not fit on my primary page, and it would be beneficial to be able to see those entries in some condensed form on the primary page. It seems to me that I should be able to create a field that takes the values from the repeating field for a particular record and show them with a seperator between values. Does that clarify what I'm trying to accomplish?

Thanks,

John

The person sending you the file - done in FileMaker 3 - illustrated the use of scrolling portals to display related information. This is something you could do if you got rid of the repeats and used a standard "child" table. You *really* should get rid of the repeats. This is a classic, very ordinary one to many relationship. If you don't know how to do that - it's time to learn.

If you move to FileMaker 8, it is possible to use a recursive custom function based on the FileMaker 8 getNthRecord feature to build your calculation, and that can be covered later. But first you should learn how to use related data, since FileMaker has been relational for a very long time now.

Edited by Guest
Link to comment
Share on other sites

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