i’m a bit stuck (maybe in my head only … but definetly in my current work ): My problem: I have 3 Lists and I stuck a bit combining them the right way. Imagine it a bit as a “Food Logger”
- A list of a Person, who can have different Meals
- A list of food, a Person can choose from (e.g. Steak or Rice)
- A list of meals on one specific day including all the food (" Food Saturday")
1 Person can have multiple meals
1 Meal can have multiple foods but the Food has also different weights. Like the steak can have 200g and the rice 50g.
Where I stuck: I can make the relationship between “meal” and “food” in one “meal”-database-entry but i dont know how to add the different weights.
Hope you may help?