From list “A” I want to look up information in list “B” using a column of type “PSC Lookup”. This column is named “variants”.
I managed to have a drop down list opening in column “variants” showing the preselected columns from list “B” which I have defined in dialogue “Search fields definition (dropdown columns):”
One column in list “B” is named “tool” and I want to set the filter option to filter the dropdown for a specific tool number. I can do so using the dialogue input line “Conditions for search query (dropdown filter):” and enter e.g. “tool eq ‘123’” This works fine!
But how do I set this filter to use a dynamic value from list “A” which is found in a column (Type=text) called “reference”? I tried “tool eq reference”. But this leads to an error message saying “Column reference does not exist”.
So what would be the correct setting for having a filter set to the individual entry of a value in column “reference”?