Managing Relationships

[Anonymous]

So I have two datasets I'm attempting to merge. Both from different sources but both contain the same Company ID's highlighted in each table:

I'm unable to connect the two because my CService dataset contains duplicate co values because a company can have more than one service:



I've already tried creating a calculated table to get the distinct values, but it does not give me everything I need. I need to build some formulas but I do not know how to get around this without establishing a direct connection between these two datasets. I have retention formulas already established in my CService dataset based on the start and end dates, and I just need the account manager field from my EMS Survey dataset to add the retention formulas to see what the retention is by account manager based on the company ID my datasets in common. Any ideas??