Change Primary Data

[Anh_Tran]

Dear All,

I have 2 databases A and B, In A fd_A = primary key (Data: "Hello")

so I set relationship From A to B ( Fd_A = Fd_ so Data in B is "Hello".

Now I want to change data in A , it means now in fd_A = "Hello Mama"

how can In B fd_B = "Hello Mama" right away?

Since This problem happens many times, is there a way to achieve it so that we don't retype it or we don't lost data???

Thanks All

[Ugo DI LUCA]

Imagine I have John related to Company A (Contacts:Company::Companies:Company). If he is about to change from Company A to Company B, I wouldn't like the Company A to become Company B...