Filtering Columns on a Custom Table

[Joe Taylor]

I have a custom table with 3 columns.

I'm trying to use a reference variable in my form.

I'd like to filter Column2 pulldown in my form based the selection from Column 1.

I'd like to filter Column3 pulldown in my form based the selection from Column 2.

Here's a sample.

What's the best way to handle this?

Column 1    Column 2    Column3

10 - A         1010 - AA    101010 - AAA

20 - B         1020 - AB    101020 - AAB

30 - C         1030 - AC    101030 - AAC

etc.               2010 - BA    102010 - ABA

.                   2020 - BB    102020 - ABB

.                   2030 - BC    102030 - ABC

.                   3010 - CA    103010 - ACA

.                   3020 - CB    103020 - ACB

.                   3030 - CC    103030 - ACC

                     etc.

                     . .

                     . .

[Joe Taylor]

According to ServiceNow, DOM manipulation is NOT recommended.

Are there any other options available to me?

[Joe Taylor]

Can I use dependent values in a choice list to accomplish this?

[Joe Taylor]

Are there any other suggestions about this?

I'm currently doing something similar with my Incident Record Producer with Categories and subcategories.

Can't seem to make this work with my custom tables though.