I am using Access 2013 and have run into a problem in regards to forms / sub forms and how they work. Although I have read and looked at various tutorials for some reason I am unable to connect the dots. Please understand, I am not asking anyone to do this. Instead I am looking for me to complete this step-by-step. I am willing to break this into as many questions as needed until done.
First of all, I need to explain my objective. I am wanting to use Access to track my daily protein, carbs and fats based upon a recipe I select. My tables look like this:
This table is used to track, by date my beginning and ending weight.
DailyRecordID is an auto number field
DailyDate is a short date field
BeginningWeight is a double number
EndingWeight is a double number
This table breaks down the mealtimes available, i.e. Breakfast, Morning snack, Lunch, Afternoon snack, Dinner.
MealtimeID is an auto number field
MealTime is a text field that has a record for each of the above mealtimes.
This table contains the number of proteins, carbs, and fats that I'll associate with a recipe.
PCFID is an auto number field
Protein is a number field
Carbs is a number field
Fat is a number field
This table contains the Recipe and the protein, carbs, and fats associated with the receipt
RecipeID is an auto number
Recipe is a text field for the name of the recipe
PCFID is associated with the tblPCF
Every day I'll track the meals I consumed weighing myself before and at the end of a day. Therefore, a day should show 5 mealtimes.
I believe that I'll need another table (?) - step 1 might be where I need to start.