Count Records under certain circumstances

[Jredeemer14]

I know there are a lot of topics on this subject, but I didn't find any that fixed my problem. I'm a pretty new to filemaker so let me know if this doesn't make sense.

So: I want a field (call it InStock) that will display how many records fit a certain criteria specifically:

if instockinventory=0 and location=n

then I want it to tell me how many records there are for the field called model number.

The picture posted shows a find that shows all the records for the critera of

instockinventory=0 and location=n

and 4 records of that model number

I would like that # of found records to be put into a field called instock, so I don't have to go into find mode and search every time

My main goal was to display for each record how many of a certain model number of a product was left in stock. So that is my goal.

Let me know if you need clarification and Thank you!

[mr_vodka]

Create the calc that will return a boolean value of whether or not it fits your criteria. Lets call it cFlag

cFlag: instockinventory=0 and location=n

Then create a summary field that sums up cFlag.

Now you can create a new self join relationship keyed on model number to model number. You can now reference the RELATED self join summary field and it will give you a count for the model number of the record that you are on.

[Jredeemer14]

I can follow you all the way up to:

"You can now reference the RELATED self join summary field and it will give you a count for the model number of the record that you are on."

I'm not real sure what that means or how to do it. Could you explain it a little further?

[mr_vodka]

Put the summary field from the child table occurence on the parent table occurence layout.