Form entry locked :: join key not present

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
 
K

Ken Snell

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.
 

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

Top