Reference fields should return values related to what was selected in other fields

[rocio2]

I have created three fields on the sn_hr_core_case_workforce_admin table. All three fields are reference fields to the Topic table. 

The three fields I created are:

Taxonomy Topic -> only gives me values that have a parent of X - This is all set!

Taxonomy Child Topic -> should only give me values that have a  parent topic equal to what was seleted above in "Taxonomy Topic".

Taxonomy Sub Topic -> should only give me values that have a child topic equal to what was selected in "Taxonomy Child Topic"

How can I achieve this?

[Brad Bowman · Accepted solution]

This all depends on the data relationships, but the qualifier on Child Topic should look like this:

Where 'parent' is the name of the field on the topic table and u_topic is the name of the Taxonomy Topic field.

Sub Topic would be similar, using 'child=' + current.u_child... with the appropriate field names here also.