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

Announcements

No record found.

News and Announcements icon
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 120
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
    12,878 Super User 2026 Season 1 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
    99,084 Super User 2026 Season 1 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
    5,420 Super User 2026 Season 1 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
    22,128 Super User 2026 Season 1 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.
  • Gerardo Rentería García Profile Picture
    25,555 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Item Categories and Item Attributes in Business Central: What You Need to Know - Dynamics Power Play

    Best Regards
    Gerardo

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,946 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,177 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans