editable joins

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

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

tia,
mcnewxp
 
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.
 
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.
Click to expand...
please elaborate...
 
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
 
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
Click to expand...
i think i figured it out.
i needed primary keys and had some bad duplicate data in one of the tables.

thanks,
mc
 
Back
Top