Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 8
Registered: ‎03-13-2013

Building a Group in Opportunity module in Web Client - SQL Question

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

New Member
Posts: 8
Registered: ‎03-13-2013

-Please Delete-

Apologies, was having submission issues and this forum post went in twice, and I wasn't seeing it in the forum.  Please delete this one at your convenience, thanks.

 

-John