I would like your help with this, I am trying to create a dashboard comparing budget with sales for specific users.
I do not know how to create the data model to do this correctly without creating cirkular references. Below is a picture of that part of the data model, what I would like to do is to associate the date fields in Budget and Sale.
Since I need to associate the tables on aassociate_id, I can't associate the date fields, because that causes a cirkular reference.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .