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.
 
You must log in or register to reply here.

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

Similar Threads

Have both records from two queries/tables under one Query without related fields. 0
Delete Query: Could not delete from specified tables 0
Left join in query 12
Seriously, I need ideas. Fields not transferring from table to table 3
Create update query for remaining records 10
Updateable querie 2
One-to-Many join act as a One-to-One join 2
Append Query Issue 0

Back
Top