Circular loop

Aspiring_Developer — Fri, 03 Sep 2021 17:42:39 GMT

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

Re: Circular loop

rubenmarin — Sat, 04 Sep 2021 07:52:43 GMT

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.

topic Re: Circular loop in App Development

Circular loop

Re: Circular loop