Greetings,
My SQL knowledge is limited, this may be extremely simple to answer, and hopefully it is. I'm attempting to show account names, and contact's names based on their respective SalesLogix IDs. Unfortunately, I have been unsuccessful having the ID convert to the proper name, I can get it to show the ID just fine, just not what that ID is associated with.
For example:
Opportunity.AccountManagerID I set the format type to "User Name" and that works, but Opportunity.ResellerID doesn't. Which makes sense, because ResellerID isn't a user in the system, it's an account. But struggling to find the proper selection.
Your help would be immensely appreciated.
Thank you and look forward to your replies.
Signed,
John
