change data in a union query

[Neil]

I need to have two seperate tables in access 97 (for dealing with
different types of purchase orders). The primary key isn't duplicated
between these tables and I view this data later on by using a union
query. Problem is I don't seem to be able to change / modify the data
when it is displayed from the union query. Is there any way around
this?

Cheers,
Neil

 

[Rick B]

Yes, put it all in one table instead of two. Add a field called "type" or
something similar to differentiate between the two.

 

[neilonusenet]

I need it in two seperate tables for reasons that are too long and
tedious to go into. Can anyone confirm that there's no way of doing as
update on a union query?

 

[Rick Brandt]

I need it in two seperate tables for reasons that are too long and
tedious to go into. Can anyone confirm that there's no way of doing as
update on a union query?

You cannot update the result of a UNION.