I have successfully change both master and relevant detail transactions to
new primary key fields.

Now I have the problem of changing existing detail transactions from an
incorrect key to a primary key which already exists on the master .. eg
Master key is "abc company ltd", detail is "abc company" which needs to be
changed to "abc company ltd".  The only way I can see to do this is to
create an update query which changes the detail field for all records equal
to "abc company" to "abc company ltd".  Its a lot of work, would be nice to
be able to somehow click on the old and point to the new.

Some thoughts on this would be most welcome.

Abay