Calculations based on options in a value list

[Cora]

Hi everyone,

I was wondering if you could help me understand how to achieve something (I am very new to Filemaker). I was wondering if there is a way to perform a count on the number of records that have one value in a value list in a separate field. I don't want to specify the value in the calculation dialog box, though; what I want is for whatever value that appears in the separate field to automatically be searched through all records and then be counted in the specified field. In other words, if the separate field says "Meductic Group," then I want a number to appear in the specified field that represents all the existing records with "Meductic Group" in the separate field. Can this be done?

Thank you,------------------Cora

[LaurenKuhlman]

I am not sure if I understand your request completely but this is what it sounds like to me:

You want to see how many records have the same value in a field?

Try this.

Draw a self-relationship based on the field and then display a summary field from the other occurrence.

For example, if your layout has the context of Company, duplicate your Company table occurrence on the relationships graph and rename it something obvious like Company_self. Then, draw a relationship from Company::name to Company_self::name.

Create a summary field in the Company table that is a Count of a unique field (like your primary key). For this example, I will call this summary field sCount.

Then, place Company_self::sCount on your layout with the context of Company.

This summary field will display the count of records that have the same company name.

[Cora]

Thanks for replying. This may fix my problem. I will try it out and if I need more advice I will post to this discussion again.

[LaurenKuhlman]

Glad to help. I am monitoring this thread.