I'm having a problem with a circular reference, I leave attached the catch.
Basically it is an application that analyzes sales, it has customers, items, sales, and a calendar.
The problem is that I was asked for a tab that shows, among other things, the number of active customers (per month-year), for each seller (as you will see, the relationship is one-to-one between seller and customer).
I already have a table (CustomersPerSeller -> (ClientesPorVendedor)), where the fields are: seller, month-year, otal (number of active customers).
Any way to fix it?
Is the correct way a linked table?, should i re-estructure all the data?