I saw similar posts on the subject but somehow cannot work it out.
I am creating product made of different ingredients / quantities e.g the “English Breakfast” product would be made of Bacon x3 and Eggs x2 (I know; frugal :))
I also need to be able to keep track of the quantity left for each ingredient (so that I can re-order if needed) so the inventory side of the app is quite important as well.
What is the best way to store those values? At the moment, I went where 2 list of things (one for ingredient and the other one for quantity. So in practice I have ingredient = egg, bacon and then quantity = 2 , 3 stored in my database.
Is it the best way to do it?
I went ahead with the 2 list of things.
I created a repeating group so I can see the ingredient / quantity added to make the product. For some reason there is no data populated after row 1. Any idea on why this does not work?
This is the RG in the editor
This is the database structure
And the RG in preview