I have lost touch using Access 2013.
My database is VERY simple. Two tables and one form. The purpose of this database is to track receipts and the protein, carbs and fats associated with the receipt. I have hundreds of receipts and their associated protein, carbs and fat contents. What I'm trying to do is assign the correct number of proteins, carbs and fats to each receipt.
Table one is called Receipt has three fields: AutoNumber, Receipt (text field) and a field I call PCF (number).
Table two is called PCF and has four fields: AutoNumber, Protein (number), Carbs (number) and Fats (Number)
My form let me enter in a receipt name I'm also using a list box based upon table two PCF, that gives me various combinations of protein, carbs and fats.
There are also three text fields: Protein, Carbs, Fats. When I select from my list box the combination associated with the receipt I would like to display in each text box the protein, carbs and fats that I selected.
My question is how do I show in my text boxes the protein, carbs and fats?