How to pass the primary key id automatically as foreign key id in other table.?hi frnds..
Here am having 2 tables names t1 and t2....t1 as columns as follows id as primary key auto generated,name,dept,desg....in table t2 also having the same columns as table t1 but only change i have not declared id as primary..here i have to pass value of primary key from the t1 and pass it as a foreign key for the table t2 automatically..wt i have to do...how can i pass this...any one please help me...
Looking forward for your answers
Thanks & Regards