Manufacturing Inventory Help
I've been trying to create a program that will suit my needs, with no luck. I've been through forums, /r/filemaker, and Lynda.com, and I'm just not getting it.
I need a FMP12 Database that can organize this data:
1. List of my Products
2. Master Parts List of all parts within that compose my products
3. Product Recipe Table that shows what each Product is composed of.
A few things to note:
I am beyond lost. I don't know what my field will be that solves my many-to-many problem.
My most recent idea has been to create recipes for each product, but I just can't apply any of that due to my lack of knowledge.
If someone could build a template for me, I'd be eternally grateful. None of the starter solutions apply to me.
That recipe is traditionally referred to as a bill of materials or BOM. The typical "backbone" set of relationships for this would be:
Products::__pkProductID = BOM::_fkProductID
Parts::__pkPartsID = BOM::_fkPartsID
For an explanation of this notation, see: Common Forum Relationship and Field Notations Explained