Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

fields

Posted on by Microsoft Employee

ms crm change field name based on other field name for example, if we keep texas in a field it should me colleges in the texas list in another field can body help me with using java script and advanced find

thanks in advance

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: fields

    if there are multiple states like texas, missouri etc and multiple university

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: fields

    Based on the example that you show above, the best solution will probably be dependent lookups.

    You would choose the state in lookup 1, and lookup 2 will show you the available colleges in that state (the state must be a lookup field in the colleges entity).

    This is an out of the box feature.

    For the second lookup (the dependent lookup), you will need to open the form, and go to the lookup properties.

    In the related record filtering, check the Only show records where box

    Select the parent field name in the first box and the same field in the second box with the related entity name in parentheses.

    See below sample:

    relatedrecordsfiltering.png

    In the screenshot above, my Task lookup (second lookup) will only show the Tasks, where the selected Project (first lookup) has been selected.

    Hope this helps.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans