I have 2 tables which are identical: 1 called modacad, 1 called paths. Both tables contain 2 fields i.e. Mainkey and Path. If I browse the Paths table I will see:

Key                              Path
T57*SS2003*JKT001*SAMPLE         U:\Data
T57*SS2003*JKT002*SAMPLE         U:\Data
T57*SS2003*JKT003*SAMPLE         U:\Data

If I browse the modacad table I get:

Key                              Path
T57*SS2003*JKT001*SAMPLE         
T57*SS2003*JKT002*SAMPLE         
T57*SS2003*JKT003*SAMPLE         

I would like to now create a command which will copy the path from the Paths Table to the Modacad table where the keys are the same. Therefore the modacad table will look like the Paths Table.

Any help would be greatly appreciated as I replaced the paths by accident in one table and now have to go to backup tape to resolve.

Many Thanks