topic How to create link table? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-link-table/m-p/152113#M29684 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have two tables, I want to use link table to avoid syn key. How to do it?</P><P>Orders:</P><P>OrderId, LocaleId</P><P>Revenue:</P><P>OrderId, LocaleId, Amount</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 04 Jan 2011 08:48:54 GMT 2011-01-04T08:48:54Z How to create link table? https://community.qlik.com/t5/QlikView/How-to-create-link-table/m-p/152113#M29684 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have two tables, I want to use link table to avoid syn key. How to do it?</P><P>Orders:</P><P>OrderId, LocaleId</P><P>Revenue:</P><P>OrderId, LocaleId, Amount</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 04 Jan 2011 08:48:54 GMT https://community.qlik.com/t5/QlikView/How-to-create-link-table/m-p/152113#M29684 2011-01-04T08:48:54Z How to create link table? https://community.qlik.com/t5/QlikView/How-to-create-link-table/m-p/152114#M29685 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>If you have multiple fields to link betwen the two table then you can composite key to avoid the syn key.</P><P>eg:</P><P>(OrderId &amp; LocaleId ) as Key in bothe fields and comment Orderid and localeId in one of the table.</P><P></P></BODY></HTML> Tue, 04 Jan 2011 09:34:51 GMT https://community.qlik.com/t5/QlikView/How-to-create-link-table/m-p/152114#M29685 deepakk 2011-01-04T09:34:51Z