Circular Dependency

[luisbarreto]

Hello, everyone!

I can't see any sense on a circular dependency error message. Can you help me?
I have two tables "Pedidos Originais" and "Pedidos" (1 to N) and two columns: IMR 2 and IMR 3. These columns on table Pedidos Originais are the sum of Pedidos. The problem is that we generally have this error message when these columns refers one to another, but it's not happening, as you can see in the following images.

Notes:

1) I can't activate this relationship to avoid ambiguity, so I use USERELATIONSHIP.

2) I tried using ALLEXCEPT, but it did not resolve my issue.

Thanks!

[technolog]

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.

[luisbarreto · Accepted solution]

Hello, Technolog.
I resolved this issue by changing the link (the main and secondary) between the tables. It was not the best option, but it resolved. I expected some way to link these 3 tables successfully without any "quick fix" bypassing the problem without treating it.

Once I had one link that I could use more comands without circular dependency, I used it. And the other link with the other table I used the other commands that did not resulted in circular dependancy.

[technolog]

Thanks for sharing!