Dependent drop downs

JohnnySnow
Mega Sage

Hi Team,

 

We have a requirement in a catalog item to implement dependent dropdowns. There are three lookup select boxes — SB1, SB2, and SB3 — each containing multiple dropdown values.

 

What is the best practice for configuring dependent dropdowns in ServiceNow?

 

Our Current Approach
We have added all dropdown options into the sys_choice table as below:

Table: sys_choice
Element: SB1
Value: abcd

 

Questions

Is it okay to use sys_choice and set the Table field to "sys_choice" within the sys_choice table itself? if not where should we put the choices if the number of choices are less than 30.

Should we be using a different table instead?

OR

Would it be better to create a custom table to store all lookup values and then configure the dependent dropdowns using reference fields and reference qualifiers?

 

 

10 REPLIES 10

Update:

I went ahead and added the choice in syschoice table, with the table selected as sc_cat_item and unique element.