I have this table of products and their associated representative
I also have a fact table with the fields Order, Date, Product, and Sales.
I want to find a way to join the reps associated with each product in the fact table--however I do not know what the best practice is for this since there are multiple reps assigned to a single product.