I am making a db for my recipes – I have three tables Name, Ingredients, and Directions.
All three tables have a field named Recipe Number. The one in the Name table an auto fill number
The Name form is the main form, and the ingredients and directions are sub-forms. I can get the recipe number to pass for the main form to the each sub-form but when I can not get it to save in the table these separate tables (Ingredients and directions) support.
Any ideas how I can achieve this would be greatly appreciated.
Respectfully,
joe
All three tables have a field named Recipe Number. The one in the Name table an auto fill number
The Name form is the main form, and the ingredients and directions are sub-forms. I can get the recipe number to pass for the main form to the each sub-form but when I can not get it to save in the table these separate tables (Ingredients and directions) support.
Any ideas how I can achieve this would be greatly appreciated.
Respectfully,
joe