Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
list box has a list of item codes
table has records with item codes that are similar
how do I select records in the table that are similar to the selected value from the list box, that is, the values in the table will be "like" the value in the table?
You can use a Select in Field action assigned to the OnSelect trigger of the field in the listbox. Choose as Field the field that contains the similar values you want selected. Use as search string ='(' & concat(distinct '*' & ItemCode & '*', '|') & ')'. Replace ItemCode with the actual name of the field in your listbox.