Circular loop

[Aspiring_Developer]

Hello All,

Request you to please help me with below scenario :-

I have below tables :-

Table A:

Load

%Id card,

%project ID

From ...

----------------------------

Table B:

Load

%userid,

%project ID

From ......

---------------------------------------------

Table C:

Load

%userid

NBhours 

From .....

-------------------------------------------------

Table D 

Load 

team_workload,

user id as  %userid,

id card as %id card

from............

=================================

My requirement is to establish below relationship:-

Table B with Table D on %userid

Table C with table D on %project id

Right now when i do this it created circular loop . And i cannot rename any field in Table D as it hampers my records. 

Can we do this by creating any key ,not sure, can anyone please help ?

Thanks in advance

[rubenmarin]

Hi, I would need to know more about what data stores each table, wich what I see in the sample I would do a Join between A and D tables, then add table B to the join.

If needed, you can oly join the key fields, and from the joined table you can create combined keys to relate to the facts of tables A, B or D

Table C is not an issue as it ony has one key so it can be also joined or stay as independent table... if joining with the alredy joined table creates duplicates of data, it will be better to keep as independent table.