I am trying to create a specific type of database. I have made one like this in the past just don’ t remember how. This one has a main focus on recipes.
Table 1 has unique id and the name
Table 2 is a number and for each of the ingredients
Table 3 is for a number and directions. For examples: 1. Beat eggs to stiff peaks
Table 1 was my main form
In the past, I have made sub forms for tables two and three.
I would create an unbound box in the main form which was equal to the unique id. For this conversation let call it Text 1.
I would then make another unbound text in sub forms two and three and link them to text 1. For this conversation lets call them text 2 and text 3.
I would then link text 2 to a blank field in the sub form and in-turn to the table.
I can get all the fields to populate but will not save to the table. How do I get the information to save to the table?
thanks
Table 1 has unique id and the name
Table 2 is a number and for each of the ingredients
Table 3 is for a number and directions. For examples: 1. Beat eggs to stiff peaks
Table 1 was my main form
In the past, I have made sub forms for tables two and three.
I would create an unbound box in the main form which was equal to the unique id. For this conversation let call it Text 1.
I would then make another unbound text in sub forms two and three and link them to text 1. For this conversation lets call them text 2 and text 3.
I would then link text 2 to a blank field in the sub form and in-turn to the table.
I can get all the fields to populate but will not save to the table. How do I get the information to save to the table?
thanks