update 1 dataset from another

I have 2 datasets "DS1! and "DS2".

Each contain, among others a field called "QTY".

I need to replace the contents of "QTY" in RS1 with the contents of "QTY" in RS2.

Can anyone tell me how I should go about this?

Thanks in Advance
Bede

You should do that kind of stuff in the database. However Datasets are made up from Datatables. These have datacolumns which you can copy from one to another.