Tech Support > Microsoft Windows > Windows CRM > Mapping..
Mapping..
Posted by GDaxon on September 6th, 2005


ok. I have a table with about... ohh 250 fields.
Lets say that one field is directly dependant on another. In this case, a
region number is given to a person based on their postal code. In SQL I could
just create a second table and link them using postal code as the key. How
can I accompish this in CRM? I'm assuming its by using the mapping feature
but in the documentation I have it tells me to go in through the SQL
enterprise manager. I have been told that I am not allowed to directly access
the SQL database without voidding my warranty. How can I make it so that the
region number can be displayed based on the postal code?

Posted by Simon on September 6th, 2005


Hi,

We have recently set something similar up using an onchange javascript
event. After the choice is made in the first picklist, the values in the
second picklist are displayed that relate to that choice only. You can enter
the onchange event using the system customisation in CRM for the field you
want.

Regards

Simon

"GDaxon" <GDaxon@discussions.microsoft.com> wrote in message
news:425C8A8B-106F-46D0-A1AD-311D49B7EA53@microsoft.com...


Posted by Reichert on December 3rd, 2005


Simon,

Can you explain in more detail how you accomplished the dependant picklists.
WOuld you mind pasting the actual code here?

Thanks

"Simon" wrote:


Similar Posts