Use more than one link table in an app?

[zakpullen]

Hi,

I currently have one link table working successfully, based on 4 common fields in 3 tables, and a key generated by autonumber using those fields. I want to add another table to my app, but it has only 2 of the 4 common fields.What's the best way to go about this? I tried adding a second key, but that didn't seem to work. If I added a second link table, that would have to link to the first link table? I'm sure I'm missing a more efficient solution.

Many thanks.

[marcus_sommer]

I'm sure I'm missing a more efficient solution.

The recommended datamodel within Qlik is a star-scheme as the best compromise between efforts and performance. Therefore I suggest to check a change in this direction.

- Marcus