Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CRM Opportunity ID

Status
Not open for further replies.

Saturn57

Programmer
Aug 30, 2007
275
CA
Im trying to tie into the CRM database with another program. I would like to be able to call up a list box of opportunity id's from the CRM database. Unfortunately when I go into the opportunity table the opportunity id is very cryptic. Our CRM software gives every opportunity a number like CRM0012 in the CRM interface. How can I get this lookup box to link to the non cryptic version of the opportunity id? Thanks in advance.
 
I am assuming you are tying this with SQL.

You need to use the filtered lookup tables. The name field will display the topic. The ID, straight from the base table will display the GUID.

The table to pull is "FilteredOpportunity"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top