how do i get around the state/provice issue with microsoft dynamics crm
Posted on 2014-10-24
I want to have a drop down for the state in the address field in Microsoft Dynamics CRM 2013 so I created a new field "state/province" and added all 50 states as an option set and then I created it in the entity for the contact and lead. This worked great because instead of using Address1, I use address 1 line 1, address 1 line 2, address 1 city, etc. and for the state I use my custom field. However, I did a N:1 relationship for the address from Lead to Contact and it will not pass the state because it is an option set and the original state is a single line of text. How do I get around this?