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
 
Back
Top