More on Access 2000 - Changing key fields in Master / detail forms

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

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
 
we need to know how many detail transactions are there so we can assess it if
coding is worth doing or just use the find and replace tool of access in the
datasheet view of your detail transaction.
 
There are many combinations of details with incorrect keys which need to be
changed to existing valid master keys. So the count of details is different
for each group to be changed.

Does this answer your question?

Abay
 
Back
Top