Maintain Foreign key
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...