Resolve Many to Many relationship Joins issue via Incorta Virtual Joins

Goal: I have a CustomerGroup table where a customer can appear multiple times (one row per Concept per time period), so customer_code is not unique in this table. I want users to filter by Concept on a dashboard and have that filter apply to our sales-orders table (SL_CustomerOrders) - showing only sales for customers who belong to the selected Concept - without duplicating or losing any sales rows . Schema setup: Customer (master table, unique key: Code + Company) CustomerGroup - Child of Customer, joined on CustomerGroup.Code = Customer.Code AND CustomerGroup.Company = Customer.Company.