Unable to append record

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Remove a table. You haven't told us anything about your table relationships,
primary and foreign keys, and your SQL view.
 
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
Click to expand...

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]
 
Back
Top