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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Cascading Enum / Option Fields in Business Central

(6) ShareShare
ReportReport
Posted on by 95
Hi everyone,
I’m working on a requirement in Dynamics 365 Business Central where I need cascading behavior between two fields, and I wanted to confirm what is technically supported and the recommended pattern.

Scenario:
I have two fields on a table/page:
  • Field 1: Product Type (Enum / Option)
    • Drives
    • Non-Drives
  • Field 2: Warranty Process (Enum / Option)
    • Required behavior:
      • If Product Type = Drives, Warranty Process should allow only:
        • Replacement
        • Credit
      • If Product Type = Non-Drives, Warranty Process should allow only:
        • In Stock 
        • Not In Stock
Questions:
Is it possible to create true cascading enums/options in Business Central (i.e., dynamically change available values in a dropdown based on another field)?
Or do we need to create a separate table and handle this using TableRelation with filters based on the selected Product Type?

Thank you.
 
I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    6,351 on at
    Hello,
     
    True cascading enums or options are not supported in Business Central because enum and option values are static and cannot be filtered dynamically based on another field. If you need the dropdown to show only valid values depending on Product Type, the recommended pattern is to use a separate lookup/setup table and apply a filtered TableRelation based on Product Type. Alternatives are validating combinations in OnValidate (users still see all values) or using separate fields with conditional visibility, but the lookup table approach is the cleanest and most supported solution.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    As far as I know, this is not possible; you would need to customize a table to manage this structure.
    For example, this can achieve a similar effect.
    Drives -> Replacement
    Drives -> Credit
    Non-Drives -> In Stock
    Non-Drives -> Not In Stock
     
    Thanks.
    ZHU
  • Suggested answer
    Pallavi Phade Profile Picture
    4,124 on at
     
    The above request cannot be acheived in Standard . We need to customize 
     
    I can suggest below solution , Requesting you to test in Sandbox 
     
    Solution 1 - Using Enums - Not that practical if new option comes in future
    1) Since visibility of options cannot be dynamic , we can restrict user from selecting wrong option
    2) Provide error while selecting wrong option
    2.1If Product Type = Drives and user selects "instock" or "Not in Stock" Warranty option then provide Error message 
    2.1If Product Type = Non- Drives and user selects "Credit" or "Replacement" Warranty option then provide Error message 
    3) This solution will work if there is no extension in enums
     
    Solution 2 - Using Table Relations . This will consume Tables, Data but it will work long-run
    1) Create Table "Product type" having  fields
    1.1 Product Type - Code [30]- Primary Key
    1.2 Product Type Description- Text [100]
     
    2)Create Table "Warranty" having feilds
    1.1 Product Type  - Code [30]- Primary Key 
    1.2  Warranty type =- Code[30= - Primary Key
    1.3 Warranty Type Desc- Text [100]
     
    3) Create Field " Product Type" in your custom table and provide table relation to Product Type
    4) Create Field "Warranty" in your custom table and provide table reltaion to Warranty Table as below 
     
    you can see error i dont have "Warranty" Table . this is just to explain how it can be done 
     
    For above solution you can control warranty type based on product type 
     
    Hope this helps 
     
     
    Warm Regards
    Pallavi Phade
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,603 Super User 2025 Season 2 on at
    Business Central does not support true cascading enums or options. Enum values are static and cannot be dynamically filtered. To achieve cascading behavior, use a separate setup table with TableRelation filters; otherwise, enforce the logic with validation if you keep enums.

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…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans