Cannot add record(s); join key of table '[table name]' not in recordset

G

Guest

I am creating a database with three tables, I use autonumber to create the ids then i relate the ids in a join table. When i create a form to enter data i get the above message when i try and add data. I have search knowledge base and not found an article relating to this
 
A

Art

Hi Tom,
Make sure that all of the primary and foreign key
fields from the tables are in the query that is behind
your form.

Hope This Helps
-----Original Message-----
I am creating a database with three tables, I use
Click to expand...
autonumber to create the ids then i relate the ids in a
join table. When i create a form to enter data i get the
above message when i try and add data. I have search
knowledge base and not found an article relating to this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Join Key not in recordset 2
Join key on table not in recordset 3
Access Passing the value to a table 1
synchronize new record in subform to related record in form 1
error: join key not in recordset 1
Open Specific Record 1
Recordset Not Updateable message 2
join key of table Car_Model_Variants not in recordset 2

Top