Unable to append record

G

Guest

I cannot append new records on query once I have linked 3 tables. I cannot
get to the new reord at all. The entire query from table is read only and
not editable. It allows to enter if I link two tables. Please advise if I
can fix this.

Thanks
 
D

Duane Hookom

Remove a table. You haven't told us anything about your table relationships,
primary and foreign keys, and your SQL view.
 
J

John Vinson

I cannot append new records on query once I have linked 3 tables. I cannot
get to the new reord at all. The entire query from table is read only and
not editable. It allows to enter if I link two tables. Please advise if I
can fix this.

Thanks

Not all queries are updateable; it would be very rare and a bit
strange to append data to a three-table query in any case. What are
these tables, and where is the data you're appending coming from?

John W. Vinson[MVP]
 

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