Changing Primary Key

N

NoviceIan

I have a table for which the primary key is staff number. I've just realised
that somebody's staff number has been entered incorrectly. I tried changing
it but it keeps saying that I cant because there are related records in
another table.

Staff number is from table Employee which is on the 1 side of the
relationship but I've just realised that the box for cascade deleted records
is not checked is that why I cant change the number?

What can I do?

Ian
 
N

Nikos Yannacopoulos

Ian,

What you need here is the Enforce Referential Integrity and Cascade
Update Related Fields checked.

HTH,
Nikos
 
Top