Form entry locked :: join key not present

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

Wierd. I have a great inner join query which I allows
me to add, modify, and delete records inside the query panel.

But when I build a form on top of the query it does not allow me to input
NEW records. Status Bar says:

"Join Key of table Listings is not in the recordset"

This does not makes sense as the underlying query has the Primary Key of the
Listings table.

Anyone know how to correct this - thanks in advance
- Jason
 
You'll need to post the SQL statement of the query. That will help identify
why the query is not updateable.

Also describe the table relationships and structures for the tables in the
query.
 
Back
Top