Relationships OK?
Folks,
I am setting up tables and establishing relationships between them. Below is how I have set them up.
My objective is to track daily my protein, carb and fat input based upon various recipes and mealtimes. I see my form as a form with sub form. Will what I've done get me there?
I am setting up tables and establishing relationships between them. Below is how I have set them up.
My objective is to track daily my protein, carb and fat input based upon various recipes and mealtimes. I see my form as a form with sub form. Will what I've done get me there?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Scott - thanks. Now I'll move to the form/subform. Appreciate all EE's
ASKER
Thanks for you comments. First of all the table tblMealTime maintains when a meal is to be taken. Mine has Breakfast, Morning Snack, Lunch, Afternoon Snack, and Dinner. Therefore, when I select a meal time in my sub form I can choose which meal I am taking.
Now it may be possible than I could have the same Afternoon snack as I had for the Morning snack. It may also be possible that I'll need a combination of menus for a mealtime to meet the target set. Does this complicate anything?
Thanks for the tip on the sub form needing to be a Continuous listing. I'd forgot about that.