Help: Circular Loop

[#1]

Hi All,

Please help me how to eliminate this circular loop, when I try to connect the table in red box to the calendar it produces a circular loop.

[#2]

Hi Mars,

have you tried to rename DateKey in one of the table and duplicate the same field in the other table!?

I mean:

In FiscalCalendar table you duplicate DateKey so you have DateKey and DateKey_2.

In WattTransaction rename DateKey to DateKey_2

I don't know your goal so maybe it's not correct but you can try.

Hope it helps

Giampiero

[#3]

it still produces circular loop.. any other advice??

[#4]

I see,

the problem is "CmboMapp..." Table.

Try to avoid the link between WattTransaction and ComboMapp tables (renaming in WattTransaction table the field Output_LINK)

In this way you should have these links:

Ledger --> FiscalCol --> WattTransaction and Ledger-->ComboMapp...

Again, I don't know your goal so maybe this is not the right solution but you'd want produce circular loop.

Hope that helps

Giampiero