counting similar values in field

[rrric]

I'm fairly new to filemaker and creating an inventory db using and modifying the template in FM. I want to be able to count reoccurring values in a "Model" field so I can generate an "On Hand" field. Suggestions?

[merlyn383]

IMO, the best way to do this is using a self join. In "Define Database" to to the "Relationships" tab. Create a second instance of your main table called OnHandCount. Define a relationship between your Main Table and Count in the following manner:

Model X Model

Model = Model

Then, in the Main table, create your OnHand field as a calculation using the following definition "Count ( OnHandCount::Model )"

Don't actually put the quotation marks in the calculation.

Obviously, the actual table names and field names are up to you, just be sure to be consistant.

[rrric]

Thanks so much for the help. I'm pretty much a rookie trying to teach myself. I'll try this when I get to work tomorrow.

[rrric]

Tried what you suggested - worked great! Kudos for the advice, much appreciated.