Hi,
I agree with David. You should create N:1 relationship with the contact entity. But if you still want to go with the picklist option then see the below solution:
MS CRM provides a very good feature of calling MS CRM Web Services using Javascript. On the form load you have to call the Javascript Web Services to Query the desired entity from where you want to fetch the details. It returns the XML with the Entity details.
Retrieve the details and pre populate the Order Form attributes with the result.
So, you have to work with Client Side Web Services - MS CRM
Please refer below link - how to work with client side web services with MS CRM.
http://www.stunnware.com/crm2/topic.aspx?id=jswebservice2
And here is the tool which generates the Javascript Code (very helpful):
http://www.stunnware.com/crm2/topic.aspx?id=JSWebService
You have to retrieve all active contacts, loop through the resultset, start adding items to the picklist control.
Hope this helps.
Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant
