On Nov 9, 10:09 am, cashotte <hottefl...@gmail.comwrote:
Hi,
Is there a way to have a union query (2 tables) in an other query then
join a third table having the ability to edit records in the third
table?
Thanks,
Stephane
You would have to edit the 3rd table without the join. If you have a
form that allows the user to edit this 3rd table while displaying data
from the union query, you would have to set a filter on the union
query to display the related record from the 3rd table.
For example, you could create a form that can be used to edit the 3rd
table. Within this form, you could create a subform to display any
records from the union query that are related to the 3rd table.
Or, if you're doing a lot of VBA, you can create an unbound form and
query your data sources separately to display the data. Then, do
UPDATEs only on the 3rd table.