web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / [CRM4.0] Filte...
Microsoft Dynamics CRM (Archived)

[CRM4.0] Filter the lookup content

(0) ShareShare
ReportReport
Posted on by aki 160

Hi,

I created a new entity and defind two attributes - Country and City .

The entity has data like this.

Country     City

Japan        Tokyo

Japan        Osaka

America     NewYork

America     Washington

I'd like to put these attributes on the Account entity and when users select a Country ,I want them to see filterd values on the City attribute.

For example, when users select Japan they see Tokyo,Osaka on the City attribute.

How can I manage that?

Any assistance would be greatly appreciated.

Aki

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Aki,

    In the subject you mention lookup. This makes me think that you do have a lookup for country and a lookup for city. Both the lookups you want on the account screenn and if somebody selects a country, then the available cities should be only those linked to the same country. This can be done by using the addon of Stunnware (http://www.stunnware.com/).

     In your post you are talking about two attributes though. This makes me think that you do have two picklists which contain countries and cities. If this is the case, then you can filter the second picklist by using javascript. There is a great example available in the SDK.

     Hope this helps,

    Ronald Lemmen
    Dynamics CRM MVP
    http://www.ronaldlemmen.com

     

  • aki Profile Picture
    aki 160 on at

    Hi Ronald,

     Thank you very much for your reply.

    I'll check the example in the SDK.

    regards,

    Aki 

     

  • Jim Crook Profile Picture
    Jim Crook on at

    Like many, I was suprised filtered lookup does not come out the box with CRM 4 and have read the many javascript and add on solutions like stunnware.  I would but the offering, but it appears the Stunnware solution won't work with Roll up 2, so I'm back to square one.

     I've instigated a pseudo solution taken from http://forums.microsoft.com/Dynamics/ShowPost.aspx?PostID=2827530&SiteID=27

    which works fine for onChange events on the source field.  However, it won't work for a situation where I have already mapped through the record into the field such that the OnChange Event never changes. 

    Any client side solutions or other "easy" solutions for a novice like me?

     Thanks

     Jim

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans