topic Re: Primary key & foreign key in QlikView https://community.qlik.com/t5/QlikView/Primary-key-foreign-key/m-p/889879#M310074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>"foreign key" is a term out of database_management I think. It's not so relevant in QlikView.</P><P>What you have to care about is only, when you hover over the key_field of a table in the Table_Viewer in QlikView, whether it reads "primary key" or "perfect key" - both of those mean the key is sufficient to uniquely identify a record - or just "key" - that means there are duplicates on this field.</P></BODY></HTML> Thu, 23 Apr 2015 09:10:24 GMT datanibbler 2015-04-23T09:10:24Z Primary key & foreign key https://community.qlik.com/t5/QlikView/Primary-key-foreign-key/m-p/889878#M310073 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P>What is primary key &amp; foreign key ?</P></BODY></HTML> Thu, 23 Apr 2015 09:04:36 GMT https://community.qlik.com/t5/QlikView/Primary-key-foreign-key/m-p/889878#M310073 qlikview979 2015-04-23T09:04:36Z Re: Primary key & foreign key https://community.qlik.com/t5/QlikView/Primary-key-foreign-key/m-p/889879#M310074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>"foreign key" is a term out of database_management I think. It's not so relevant in QlikView.</P><P>What you have to care about is only, when you hover over the key_field of a table in the Table_Viewer in QlikView, whether it reads "primary key" or "perfect key" - both of those mean the key is sufficient to uniquely identify a record - or just "key" - that means there are duplicates on this field.</P></BODY></HTML> Thu, 23 Apr 2015 09:10:24 GMT https://community.qlik.com/t5/QlikView/Primary-key-foreign-key/m-p/889879#M310074 datanibbler 2015-04-23T09:10:24Z