topic foreign key problem in Application Development and Automation Discussions

foreign key problem

Former Member — Sat, 07 Apr 2007 07:53:18 GMT

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

Re: foreign key problem

Former Member — Sat, 07 Apr 2007 07:56:39 GMT

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

Re: foreign key problem

Former Member — Sat, 07 Apr 2007 08:10:30 GMT

Hi,

Check the elements against the check table entries,

Regards

Kannaiah