Recordset not updateable

[AccessIM]

I have two tables that I would like to combine together and bring up in a
single form for updating one field.

My first thought was to create a union query to combine the two tables then
create a form based on that union query that the user could go into and
update the Reason field that appears in both tables.

However, in my research to find out why the recordset was not updateable, I
found that union queries can't be updated.

Is there another way to do this? I am trying to avoid having two separate
forms (one for each table) or two subforms on a single form.

Any help will be greatly appreciated.

 

[Douglas J. Steele]

Any reason why you have two separate tables if they're supposed to updated
together?

 

[AccessIM]

The information is imported into the database from two different mainframe
system reports. Both are for inventory adjustments but they don't have the
same fields in both reports because they are generated through two different
processes.