Data source join error

[Former Member]

Hi All,

I am trying to create a new data source using 3 native tables:

1. Opportunity Involved Parties

2. Employee Master Data

3. User Current Status

I have created a left join using #1 and #2 above, joining 1.Party to 2.Employee

Now i want to join in table #3 to #2 on 2.User ID = 3.User

But i keep getting the error shown here.

How can i join this third table to the second table?

Thanks in advance

[former_member185671]

Hi,

It looks like you are trying to join a numeric field (ID) with a text (user).
You should try to join only related type fields with each other.

Maybe a user ID field on the User Current Status table.

.CV

[Former Member]

Thanks when we changed the join type to Inner Join, the join pair "worked" - actually on the yellow warning came up, but i was able to click Save and Close..weird. When i previewed the data source it actually worked as expected. So it didn't prevent me from saving that data source with that one last remaining warning...