Reference Qualifier question

[Sam10]

Hi Guys,

I'm stuck in this issue for hours and hours and appreciate if anyone can jump in and help me out with this. 

So I have a catalog item, there's two fields. branch (select_branch) and member (Member). These two are reference fields that looks up to the table "u_branchmembers" and the technical names in the table for those two are u_branch and u_member respectively.

So when somebody open up the form and select a branch , I need the options in the drop down to filter and show members who are part of that branch. (branch and members have a 1 to Many relationship).

eg: u_branchmembers

Member	Branch
Ashley Barnes	New York
Kate Infield	Detroit
Daemon Wayne	New York
Ashley Barnes	Detroit

When selected Branch is New York or Detroit, two options should be shown but Ashley Barnes should be an option both times as she is a member of both branches. 

How do I accomplish this? 

[Vrushali Kolte]

Hello @Sam10 ,

Can you try below reference qualifier query and check if it works?

u_branch=current.variables.select_branch

If my answer solves your issue, please mark it as Accepted✔️ and Helpful 👍based on the impact.

[Sam10]

Hi Vrushali,

Tried it but no luck. My members field options come out unfiltered.