Hello everyone. I’m having some troubles to have 5 tables loaded without creating circular references and containing all connections needed. See below my data model:
The issue started when I noticed JV table wasn’t connected to stores table and it was messing up with the report. When I forced them to be connected, it became circular.
Basically, the mapping table contains where a data in “LC” and “JV” tables should go. For example, an entry on account X on “LC” table should go to [OP Line] 1 as well as an entry on “JV” with account Y.
The “chave2” and “chave3” fields are concatenations created to avoid synthetic keys.
Do you guys have any suggestion to me to have this problem fixed and the report being able to be filtered by any field on the “stores” table?