I currently have a table of items that can be combined to create another item.
Here's an example:
An example combination could be combining a 1 and 2 dose together to create a 3 dose.
I would like to be able to create a relation between these items but I'm unsure of the best way to store this info.
Do I create a table for "recipes" that contains a column for "ingredients" which contains ID's to my items.
Or would you create a many to many style table?
I also need to be able to see what combined items will provide the cheapest way to the "end" item, so to speak.
Items tabel contains: