There must be a better way do to this?
I have two tables - one with my inventory list of ingredients with information like: date of purchase, cost, description, quantity, etc – and another table with my perfume formulation (aka recipe). I really like being able to link my recipe ingredients to my inventory so I can easily go back and refer to my notes about that particular item. I also need to be able to log the quantity of the ingredient used. To achieve this I just have everything separated into multiple rows - but this makes things messy when you do any sort of reporting or alternate views or cross-referencing. This also makes the log longer, because instead of one recipe per row, there are multiple rows depending on how many ingredients I use.
There must be a better way to log the recipes I am working on? I also log as I am working on it, so the easier to edit the better.