editable joins

M

mcnewsxp

if a query contains 1 or more joins is it true that the rows are not
editable?

tia,
mcnewxp
 
J

John Spencer

No, that is not true in Access.

A query with multiple tables can be updatable. It depends on how the query
is set up, what fields are included, the table structure, etc.
 
M

mcnewsxp

No, that is not true in Access.
A query with multiple tables can be updatable. It depends on how the
query is set up, what fields are included, the table structure, etc.
please elaborate...
 
I

Immanuel Sibero

mcnewsxp,
This is covered in Access help file (A2K). In the answer wizard, type in:
update data from a query?

from the resultant topics, select the third:
When can I update data from a query


HTH,
Immanuel Sibero
 
M

mcnewsxp

mcnewsxp,
This is covered in Access help file (A2K). In the answer wizard, type in:
update data from a query?

from the resultant topics, select the third:
When can I update data from a query
i think i figured it out.
i needed primary keys and had some bad duplicate data in one of the tables.

thanks,
mc
 
Top