Union query plus editable table

[cashotte]

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

[Technolust]

On Nov 9, 10:09 am, cashotte <hottefl...@gma il.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.