Sort Combo by selected value

Kinetic ERP
,
1

Hey there everyone!

Need some help figuring out the syntax for something. I have a combo box that is populated by a BAQ using the Advanced section of the combo. I then set the value field and text field to UD20_Key1. Now, I have another value in that UD table entry that that is UD20_Character01. I need to be able to show only the entries for UD20 that the current selected entry of UD13 and its ShortChar01 match the value of the UD20ā€™s Character01.

I managed to get it to work when hard coded but not when i try something like this. Iā€™m assuming my syntax is just wrong.

//this works

image
image478Ɨ462 3.83 KB

//this does not in either row filter or search filter

image
image502Ɨ166 10.9 KB

2

Should be single quotes, I think.

Is the value of UD13.ShortChar01 being stored anywhere? Is this from a dataview?

1 Like
3

yeah, UD13 is a dataview. When i check debug, the value of the current selection is stored there

1 Like