Changing data on joined query

[LARiot]

Is there any way of making a Select query with joins updatable (not an update query)?


-Neema

 

[dhookom]

I'm not sure what you are asking. A query with multiple tables can be updateable if the join fields are based on primary and foreign keys. The use of subforms generally reduces the number of tables in any query.

If you continue to have issues, reply back with your table structure, SQL, and relationship information.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fneily]

See:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp