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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Alternate OptionString...
Microsoft Dynamics NAV (Archived)

Alternate OptionString Values

(0) ShareShare
ReportReport
Posted on by Mosaheb 952

In Item Card, I've created two new fields (Field 1 and Fields 2) with Data Type: Option

The opionstring values for FIELD 1 are A, B, and C.  The optionstring values for FIELD 2 should change depending on FIELD 1 selection.

In fact, if FIELD 1 is A, then FIELD 2 should display 1,2,3 and 4

If FIELD 2 is B, then FIELD 2 should display 5, 6, 7 and 8

Does anyone can inform how the above can be implemented 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    jcastro Profile Picture
    jcastro 2,245 on at
    RE: Alternate OptionString Values

    What I meant with the table suggestion is something like this. Create a table like:

    Option Linked to
    1 A
    2 A
    3 A
    4 B

    And then filter the table relation by the option selected in the Field1. If A is selected, it should display as available options only 1, 2 or 3. The user chooses one of them. Internally the options are stored as integers, so your 'A' might translate as a 1. Beware of that. Or you could just code your way and not rely only on Table relation.

  • Mosaheb Profile Picture
    Mosaheb 952 on at
    RE: Alternate OptionString Values

    I'm using NAV 2013 R2 Build 36366

    In fact in the FIELD 2, I want to display the option 1,2,3, etc as dropdown menu so that the user can choose one value.  Hence, table relation will not be appropriate as no single value can be selected

  • Verified answer
    jcastro Profile Picture
    jcastro 2,245 on at
    RE: Alternate OptionString Values

    I do not believe you are able to create conditional Option strings in NAV. I can think of a couple of options, but both require some coding. By the way, what NAV version are you using?

    .- You could simulate that by either creating a related table to hold the relation (options 1,2,3 are linked to option A - options 4,5,6 are linked to option B, etc) and you would be able to give the user the opportunity to define those relations or change them yourself easily. Although I do not know if that is something you need. If you went for this you could use the conditional relation feature made for fields with table relations.

    .- Or you could hardcode a form/page to open up the list of options depending on the option selected at Field1 and retrieve the choice made by the user. This option does not require another table but it's less flexible and not as elegant.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans