I've tried so many different ways to do this and I can't find a good way to accomplish this.
My thought is to use the many-to-many intermediary table to relate one product to many ingredients, each with their own properties... Since various products can have the same ingredients.
I have no idea how to handle the form creation for this scenario! I want to have a form where you can create a new product or pull up an existing product, then have a continuous subform where you can add a list of ingredients and quantities of ingredients related to that product. How would I start this?