I am starting a new project here and want to make sure I am on the right track with how I'm laying this out...
The idea is to be able to track the ingredients that go into each recipe and easily track the costs as ingredient prices change.
I plan to use a many-to-many relationship which will store a list of ingredients per product. Is this the right way to do something like this?
What I'm trying to do now is to make a form based on the Recipes table where you can select an existing Product and add Ingredients to it... but I'm having trouble with this. Anyone have a resource for a similar database? I started by thinking one form with two subforms, one each for Ingredients and Products. I'm just kind of stuck on where to go from here.