data entry into a form to populate linked tables

[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

 

[Dirk Goldgar]

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!

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.