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

    Straight Table Fuzzy Search

      Hello,

       

      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:

      Abc

      Ad

      Bc

       

       

      Values in Table Field X:

      Abc;Ad

      Abc

      Bc;Ad

       

      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!