Does anyone know if it is possible to have a Union Query that is writable? I
have two tables for parts shipped, spares and repair. After they have
shipped, serial #'s are entered on one main page. I would like them all to
be in one datasheet rather than two to make things less confusing. Maybe I'm
just going about this the wrong way by doing a Union, but don't know any
other option.

here is my query as of now (that is not a writable format):


SELECT MultipleOrderID, PartNumber, SerialNumber
FROM MultipleOrderParts
UNION ALL SELECT MultipleOrderID, PartNumber, SerialNumber
FROM MultipleOrderSpareParts;


Plesae help????


thank you!!

--
Amanda