Hi all,
I am building a base that should help me build diets for my customer.
In one of the tables, there are all the foods I can use (800+ records), each of them with nutritional data, as the nutritional tables on the foods boxes, to be clear.
In another table, I would like to link records from the food table, and summarize nutritional facts from each of them. This is easy, also with multiple records linked, using the rollup field.
The problem is: I would like to add a specific amount of each food (a quantity, so to speak), and calculate nutritional facts from each linked records and summarize the results.
For example:
I would like to add an apple to my diet, but the food table has nutritional fact for 100g of apple and I would like to add 250g of apple in the diet table.
If I have to link just one record, it would be simple, I add another numeric field and use it as a multiplier for the nutritional facts. But since I am not sure how many food items will be in each meal, I would like to link multiple records from the food table to the diet table into one field that represents the specific meal, and for each record add the multipler and then calculate the nutritional facts for the amount of food I selected.
Any idea on how to do it without creating a linked record field for each food? Is this possibile, somehow?
Thank you