relationship help

Hi,

Not sure if this is relationship question or maybe a best practice question..  either way, i have 2 tables being loaded into BI. 

1. Sales detail

2. Customer dimension (which has a customer name and sales rep name)

The sales detail report has a code for sales reps, it is not clean, which is why we went with using customer name to sales rep name.  However there are some accounts being split between two sales reps and i'm not sure of the best way to get the reporting to work.

Example below:  Honda is primarily sold from Sam (sales code 1), but sometimes sold by Bob (sales code 2). 

Ford is similar, sales primaril from Bob (sales code 2), but sometimes sold by Tyler (sales code 5).

I understand if i create a sales code dimension and build the relationship off that to get the sales rep name correct but the problem is the data by sales code is very messy and we are much cleaner using customer name at this time.  But there are a few accounts that are actually split where we want to have dual owners for one customer.   

thank you for the feedback.

Sales data

Customer dimension

Output:

Correct output: