Creating a list of parts with quanites in data type

[robhblake]

Hey @david.joshua.foreman

Interesting, I just replied to a very similar situation this morning. Here’s the link to my suggested database set-up for that (which was about recipes and ingredients but similar approach)

Best approach for handling paired values + help on displaying list of things in RG

Hi there, 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. Q1 What is the best way to store those values? At the moment, I went where 2 list of …

Rob