foreign key problem

[Former Member]

Hi,,

i m trying to inserting the element in the table but in case of foreign key some problems are arising in those fields which r foreign key in particular table .

while inserting the values to that field if data does not exist still it is accepting the data and we get the result as data is successfully created

pls give the solution so that we can continue with our work

regards

Anushree

[Former Member]

Hi Anushree,

in this case...make sure that the field which is foreing key to some other field...

is the primary key in that original root table.

i mean if field F2 is the foreighn key in table T2 to the field F1 of table T1....F1 must be the primary key in table T1.

<b>Reward points if helpful,</b>

Regards,

Tejas

[Former Member]

Hi,

Check the elements against the check table entries,

Regards

Kannaiah