foreign keys

[Flipkonijn]

Hello, i'm not sure if this thread is in the right section, but here it goes.

i have 2 tables, and in the 2nd table, i have a foreign key that is primairy key in the first table.

now i am updating the primary key in the first table. Is their a possibility to let it automatic update the second table? So that the foreign key is still the same as the primairy key?

Its a realy weird design, i know, but i havent designed the DB, i only need to adopt it.

tnx in advance!!

 

[Sebastian SITC]

Use OLD BUFFER to get the old value, then update the children in the WRITE trigger. Better redesign the crap, primary keys must not change, never.