Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Foreign Key

Former Member

‎2015 Dec 15 5:45 PM

0 Likes
582

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

2 REPLIES 2
Read only

paul_bakker2
Active Contributor

‎2015 Dec 16 1:52 AM

0 Likes
557

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

Read only

Former Member

‎2015 Dec 16 3:48 AM

0 Likes
557

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