MarkDownMark
Registered User.
- Local time
- Today, 12:58
- Joined
- Sep 10, 2016
- Messages
- 12
Hi all,
Fairly new here and I'm having issues trying to figure out why all of a sudden a db I have and was working is no longer working. The database is something I created for my wife to save her time to figure out her cost of goods for soaping products she makes. I created it several months ago on an older version of Access and after some testing (2010 & 2013) it was working but we never really used it until today. I went in and cleared out all of the tables and wanted to start from scratch. We added the ingredients and went to start making different recipes and this is where I was getting the "Cannot Add Record Join Key of Table Not in Recordset" error when listing ingredients for each recipe. I've looked and I can't seem to figure it out since I'm still pretty new to Access.
If you click on the New Recipe button and then go back to one of the recipes, you can then try to add an ingredient below. When clicking on the ingredient, it gives the error. I feel that it is tied to the Recipe Name not auto populating based on the recipe you're on but I don't understand how to get it to do that.
I've attached the database so you can open it up and see what's happening.
Any and all help is greatly appreciated. Thank you all!
Fairly new here and I'm having issues trying to figure out why all of a sudden a db I have and was working is no longer working. The database is something I created for my wife to save her time to figure out her cost of goods for soaping products she makes. I created it several months ago on an older version of Access and after some testing (2010 & 2013) it was working but we never really used it until today. I went in and cleared out all of the tables and wanted to start from scratch. We added the ingredients and went to start making different recipes and this is where I was getting the "Cannot Add Record Join Key of Table Not in Recordset" error when listing ingredients for each recipe. I've looked and I can't seem to figure it out since I'm still pretty new to Access.
If you click on the New Recipe button and then go back to one of the recipes, you can then try to add an ingredient below. When clicking on the ingredient, it gives the error. I feel that it is tied to the Recipe Name not auto populating based on the recipe you're on but I don't understand how to get it to do that.
I've attached the database so you can open it up and see what's happening.
Any and all help is greatly appreciated. Thank you all!