How to create dependent drop-down list in NetSuite

power by: https://www.excel-easy.com/examples/dependent-drop-down-lists.html

User Story: As a SA, I want to have two drop-down list in Item record, 1 is list of city, 1 is list of district, so that I can make sure user won’t select wrong district.

  1. Create City custom list.
Create City custom list

2. Create District custom record

Create District custom record

3. Under District custom record, create a custom field call “City” with type = “List/Record” and List/Record = “City” ( the custom list we just created).

Create City custom field

4. Let’s add some district data into this custom record.

District list

4. Create two custom field on Item record.

4.1 Create City custom field, with type = “List/Record” and List/Record = “City” ( the custom list we just created).

City custom field

4.2 Create District custom field, with type = “List/Record” and List/Record = “District” ( the custom list we just created).

District custom field

4.3 on District custom field, we want the value should be filtered based on the value of City custom field. Go to Source & Filtering subtab, add following criteria.

District filter

5. Go to Item record. The District custom field options should be related to the City field now.

City-A only show District-A
City-B only show District-B

Enjoy!