Access 2000 - Changing key fields in Master / detail forms

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

Abay

I have a multiform (2) screen with a master detail relationship between
sets.

I need to change some primary key fields in the master and also change the
relevant field in the associated details to keep matching sets together.

Is there a way I can do this without manually going into each detail
transaction to change the field to match the new key field in the master.
e.g. change a master primary key of "ABC Company" to "ABC Company Ltd" and
at the same time change all the detail transactions with "ABC Company" to
the new "ABC Company Ltd" name.

Any help would be much appreciated.

Abay
 
If those two forms are bound forms then all you need is just change the
relationship of your tables, the table of your master form and the table of
your details form. In the relationships window, check if you have already set
your tables relationship, if not then set if first then at the relationship
dialog box check enforce referential integrity and cascade update related
fields.

zaqyu
 
Many thanks for the information .. something that I should have known, but
as I've said many times .. teaching myself as I go along .. really
appreciate your help.

Abay
 
Back
Top