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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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 2007 - Adding Data to Form 2
You cannot add or change a record because a related record is requ 7
Access Passing the value to a table 1
Forms: not working right with tables. 4
Form will not add new record 1
Recordset Not Updateable message 2

Back
Top