Hello all, my problem is as follows. I have a PurchaseOrder table and a PurchaseOrderDetails table. I made a form to enter the purchase orders. and works correctly. I also have a query that finds the products that need to be ordered from an specific supplier. What I would like to accomplish is to get the result from the query and enter it into the form so that the data gets written into the respective tables, and the Purchase order is generated automatically. Is this possible? and if so, how is it done. Thank you for your help