I have two database; one is a purchase order database and the other is invoice database. They both use the same product, employee, shipping and customer tables; the only tables that they do not share are their order and order detail tables.
Most of the order data is the same with the acception of the invoice and purchase order numbers; what I would like to do is have a button bring the purchase orders over to the invoice database so I do not have to input all the data again.
I was thinking an append query that would bring bring the order and order details over by date but how do I do it so that the order numbers will match.