Hi, I know this may be an incredibly stupid question but here goes: I have a list of products with various models and unique serial numbers (manufacturers not filemaker). In this table a model may appear several times, I want to be able to count how m any of each product is listed (ProductA, ProductB, ProductB, ProductB, ProductC, ProductC, would return 1, 3, 2). I can't for the life of me figure this out. This would allow me to keep tabs on the number of each product in stock.

Thank you for your patience.

Tom

I would suggest a table Product Catalog. Then in the Product table, you would assign the Product Catalog ID (how else are you entering Product Descriptions so that they are identical?).

Then, from the Product Catalog table, you can relate to the Products table by Product Catalog ID and count the matches.

Product Catalog:

_kP_ProdCatID

_kF_ManfID

Desc

Model

Products:

_kP_ProductID

__kF_ProdCatID

Serial No

Bar Code?

Edited June 17, 200817 yr by Guest
added foreign key to Manfacturer table

Thanks, that worked well, I just switched from Access (ugh) to FM so my brain is still a bit crunched. I'm still getting used to the relationships, scripting and so forth in FM, sometimes I go into brain-lock I appreciate your time.

Tom