Dear All,

I am creating the inventory module, and try to convert the "Purchase Requisition" to "Purchase Order". And I need to make an Append Query to copy set of records from one table ("Purchase Requisition") into "Purchase Order" Table.

Purchase Request Table fields are:
ItemNo
Unit
Quantity

to the Purchase Order Table fields are:
ItemNo
Unit
Quantity

How could I do that using the Entity Data Source in C#.

Many thanks and best regards