Multiple foreign keys of one table in a row

[#1]

Hi there,

my first post, pls be gentle:)

we have one master data table PERSON that is referenced mutliple times in another huge table, e.g. TableX with PERS1, PERS2, PERS3.

Could  you explain the best way to link these tables? Is it necessary to refence PERSON three times, because there are three foreign keys in TableX?

All the best,

Arthur

[marcus_sommer]

I think you want apply a SQL logic on a qlikview datamodel. Quite often is this heavily complicating. You need only to avoid circular references and if possible synthetic keys and then it's quite easy. See here what is meant: Get started with developing qlik datamodels.

- Marcus