AnsweredAssumed Answered

Maintain Foreign key

Question asked by Abhaya on Mar 16, 2011
Latest reply on Mar 16, 2011 by Frinholp


Maintain Foreign key


Hello guys

Actually i'hv a simple doubt.

There are 2 tables X  AND Y

X has fields like pk_ID ,name,add'r

Y has fields like pk_ID ,color.age and fk_ID(for X pk_ID)

I want to  automatically  maintain the fk_ID in Y table whenever there is a record created in X table .

No doubt in relationship i  checked the checkbox (allow creation.... for Y)

Both pk_ID and fk_ID are  same type.

It can be done manually  or by script that is copy from pk_ID from X and paste IN Y's fk_ID..

Pls help i am a newbie...