Two table in one query

  • Thread starter Thread starter New_Access
  • Start date Start date
N

New_Access

Hi All,
I have 2 tables and unit them in a query but no join them.
Why I can't update the records inside the query/form?
Is that impossible to update the records in this condition?.

Thank's all
 
New_Access said:
Hi All,
I have 2 tables and unit them in a query but no join them.
Why I can't update the records inside the query/form?
Is that impossible to update the records in this condition?.

Thank's all
Click to expand...

No. Many multi-table queries produce read only results. This varies depending
on the number of tables, number and type of joins, and which fields are included
in the results. I'm fairly sure that a query with two tables and NO joins will
always be read only.
 
Back
Top