topic Foreign Key in Application Development and Automation Discussions

Foreign Key

Former Member — Tue, 15 Dec 2015 17:45:42 GMT

I have a field.It is made as a foreign key and not as primary key.But why dont it accept non-unique entries.Please help

Re: Foreign Key

paul_bakker2 — Wed, 16 Dec 2015 01:52:52 GMT

Hi,

Unfortunately we are not mind readers. You need to give more details about how you set up these fields & their relationships.. otherwise we are just guessing.

Post some screenshots, perhaps.

cheers

Paul

Re: Foreign Key

Former Member — Wed, 16 Dec 2015 03:48:20 GMT

May be you might have missed the following points please check the below.

1) The Thumb rule of the foreign key is that it should have data with the same entry in the parent table.

2) May be the field you have given might have some Entry restrictions. or Composite Primay key (combination of 2 or more Primary Key Fields ) is missing.

Please check this and if issue persist some screen shots would help us in giving right solution.

Regards

Veera