Data model loop issue

[#1]

I have a "loop" issue with my data load in qlikView

I don't know how to tackle this. It seem that the problem is that we can go to test from center by these two paths:

Center->patient->test and

from Center->role->user->test

I don't want to remove a link because If i remove the patient center link, I could not see the center of patients that dont have tests

and if I remove the center->user (by role) link, I could not see the center of users that does'nt have do tests.

What can I do for this ?

[Michiel_QV_Fan]

Load the field ID_PATIENT again but rename it to something else, for instance ID_PATIENT _KEY in all tables.

ID_PATIENT  as ID_PATIENT _KEY