I have a table in the name of CatoNavInt and the fields are Cato Medication ID,Order No, Customer No, Date & Time,
Item No, Batch No, and quantity.
Now I degine a another table in that fields are Entry No, OrderNo, Item No, Batch No and Qyantity.
But Problem is when I Transfer data from first table Then datahave to come in another table with a certain format i.e
All Same OrderNo, Item No, Batch No comes in a one line and quantity is total of the quantity.
I hope you understand what i ask you.
Thanks and pls reply me fast