>I have Two tables, Table A and Table B both of them are child, and both of them are indexed on the Partno and Orderno.
>i want to replace qtys in table B with qtys from table A.
>or replace data in Table A Minus (-) Data in Table B
>
>N.B. some records in table A does not have and orderno...i want only records that have Both the Partno and Orderno to be Replaced..
>Thanks For Help...
Set Exact On
Select tableB
Replace qty with tableA.qty for ;
Seek(tableB.PartNo, 'tableA', 'PartNoIndex') And ;
Seek(tableB.OrderNo, 'tableA', 'OrderNoIndex')
Backup your data before trying this! - This has come off the top of my head not tested!
HTH
Will Jones