How to resolve this circular reference

[mfcelleri]

Please, can you help me.

How can I resolve the circular reference in my structure. (see the attached)

[JordyWegman]

Hi,

Just rename this field in red:

Just remove the '%' because you can't use it as a key.

Jordy

Climber

[mfcelleri]

No resolve the issue.

I did it (see the new picture).

I think I have to change the currently structure.

[JordyWegman]

No you haven't... You have now changed them in both, but you should keep the one in the biggest table. Now you have created the same problem.

Jordy

Climber

[mfcelleri]

Ok, Jordy.

If rename the name field as llaveCliente in Cliente table; how will it be related to the Facturacion table?

[JordyWegman]

Then it will be related via the Synch table you have right now. But that problem can be solved in your other post.

Jordy

Climber