Cannot add Records; Join Key of table not...

[turntabl1st]

I am extremely new to access so I would appreciate as much help as I can get. I have been tasked with creating a database that stores product information and archives changes in price and attributes. This is what I am stuck on currently... an error message when trying to input into a text box reads "Cannot add records; join key of table "tblSciQuest' not in Record Set."



Thank you in advance and I really do appreciate the help!Restart.zip

[Rawb]

I only took a quick look at your DB, but it looks like it's a Relationships issue.

When you have a Foreign Key set up like that, you always need to add the Child Record first. In this case, that means you need to create the Record to tblSciQuest before you save the Record in tblProduct.