Populate reference variable options based off another reference variable.

[Mark OToole1980]

Hope you can help.  I am building a catalog item and need 2 reference variable to link to each other.

Variable 1 Faculty which a lookup select box referenced to a custom faculty table.  

Variable 2 School also needs to be a lookup select box referencing the custom school table.

The custom school table has a parent field that links to the Faculty table.

So I need the school variable to only show the records in the school table that have a parent of the option chosen in the faculty variable.

I have posted a picture of the simple form so far. How do I achieve this?  many Thanks

[Sandeep Rajput]

@Mark OToole1980 Could you please confirm the name of the Faculty variable? is it faculty or something else?

[Mark OToole1980]

Hi Sandeep. Actually works as a reference field, but not as a lookup select box?  Any Ideas?

[Sandeep Rajput]

@Mark OToole1980 It should work for lookup select box too. please confirm the name of the faculty variable.

[Mark OToole1980]

Hi Sandeep.  Variable name is faculty

[Sandeep Rajput]

@Mark OToole1980 I have sent you a Direct message, could you please check.