20 Replies Latest reply: Oct 7, 2013 12:38 PM by Stefan Wühl RSS

    Straight Table Fuzzy Search



      I'm trying to do a fuzzy search of a straight table.  I have a list box with possible values for a given field and I want to return any rows in the table which contain the selected values (the field can have concatenated values).  For example:


      List Box for Field X:






      Values in Table Field X:





      Therefore, if the user selects Ad from the List Box, rows 1 and 3 should be returned.  If the user selects Abc & Ad from the List Box, rows 1, 2 and 3 should be returned.


      I hope this makes sense.  I can't figure out how to do this and I've found nothing that fits my needs in all of my searching.  Thanks in advance for your help!