How to populate Lookup Select Box based on value of another Lookup Select Box?

JohnDF
Mega Sage

Hi everyone,

 

I have made a custom table. See Screenshot

JohnDF_0-1676559558621.png

Then I have my first lookup select box in a variable name "anforderungsgrund" 

JohnDF_1-1676559697139.png

 

And here is my second lookup select box:

JohnDF_2-1676559842624.png

The variable name of this look up select box is "sammelrolle" Here I have a reference qual on the first lookup select box. 

 

So in the end this lookup select box should only show the record of the table with for example I select on the first select box: "CRM / ISU" than the second should only the value "_ Keine Sammelrollen"

 

But htis dont work at the moment. It shows me both entries. 

 

What could be the problem here? Thanks for your help.

 

1 ACCEPTED SOLUTION
1 REPLY 1