I have a split database; using the same product and customer tables. Each front end INvoice and Purchase order have their own order tables and queries. I have it not so from the invoice DB I can view purchase orders but I would like to be able to send all the data from the Purchase order to the invoices. Is there a way to write the data from the view purchase order query to the invoice query.



Thanks