New to FM and I am tasked to set up a workflow for the manufacturing process of our products.
My first question is I have the following tables, but this is a Many-to-Many because the are many products that can have the same ingredient, and the same ingredient can have many products.
- Raw Ingredient
With this, I would need a join table correct?
The end goal is to show a product, and it lists the ingredients on the layout for that product.