Cascading Lookup Fields using Reference Qualifiers not working

[Suzanne_Ryan]

I'm building a scoped app.  

The main table is extended from Task.

I have a custom Lookup table that has three columns:  Program, Subsection, Test

On the main table, I have three reference fields, one for each column. 

I want to be able to choose the Program first.  Then, with the lookup table filtered on the Program value, choose the Subsection.  Then with the lookup table filtered on the Program and Subsection, choose the test. 

I've tried setting the main table fields up as choice fields using the lookup as the source of the choices, but then i can't filter it.  Plus it keeps creating new records every time i make a choice, so that's a hard no.

I've tried setting them up as reference fields as shown in the image.  Not shown - the dependent field is program.  It doesn't work. 

Not only doesn't this work, but I have reference fields to sys_user on the main table that don't work either.   I checked a catalog item dictionary entry and there was no special set up for a user field.  Not sure what I'm missing here. 

Please help.  I don't know why ServiceNow makes this so hard. 

[Brad Bowman]

Hi Suzanne,

On the Subsection reference qualifier, try:

[Suzanne_Ryan]

Thanks for your suggestion Brad.  It didn't make a difference in the result. 

[SanjivMeher]

I think, you need to make some changes to you lookup table. 

There should be a field Type, where you select Program/Subsection/Test, a name field where you put the name of the Program/Subsection/Test and a Parent field referencing to the same lookup table. In the Parent, you can put the Program, for all the subsection entries. Similarly for a Test, you can put the parent Subsection. That way you can put the required reference qualifier.

[Suzanne_Ryan]

Need some clarity on this answer, Sanjiv.  I really don't understand what you mean.  My real problem is that no matter what I put in a reference qualifier nothing happens on the choices in the lookup field - PLUS a bonus issue where any time a lookup is done, records are duplicated in the look up table.  I've had to delete it and recreated it at least 5 times so far.  

I even created a catalog item so i could have the actual lookup select field and it still did not work. 

I'm wondering if any of this is possible at all in ServiceNow - it seems to be the most obvious and simple thing that I do *all the time* in SharePoint, but I can't do it here??  I'm frustrated.  If you have a working reference qualifier, i'd love to see an example.