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?

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.

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.

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