data entry into a form to populate linked tables

  • Thread starter Thread starter Tera Yanish
  • Start date Start date
T

Tera Yanish

When I attempt to enter data into a form to populate
tables that are linked I am not able to enter complete
data and I get the message 'join key of table (name of a
specific table)not in recordset'. I am able to enter data
directly into the datasheets of each of the tables.

Any ideas or hints of what to look for would be
appreciated.

I am new to Access and have attempted to follow
normalization and relationship building conventions but
seem to have missed something important!

Thank you,

Tera
 
Tera Yanish said:
When I attempt to enter data into a form to populate
tables that are linked I am not able to enter complete
data and I get the message 'join key of table (name of a
specific table)not in recordset'. I am able to enter data
directly into the datasheets of each of the tables.

Any ideas or hints of what to look for would be
appreciated.

I am new to Access and have attempted to follow
normalization and relationship building conventions but
seem to have missed something important!
Click to expand...

When you say "linked tables", I think you're referring to tables that
are joined in a query. Is that right? Note that in standard Access
jargon that phrase would mean tables that are linked in from a separate
database, not tables that are joined in a query.

Assuming you mean what I think you mean, the problem will be in the way
you have set up the query to which your form is bound. In that query,
the tables will be joined on one or more specific key fields. Make sure
that the key field of the table that was named in the message is among
the fields selected by the recordsource query.
 
Back
Top