0 Replies Latest reply on May 30, 2015 11:43 PM by ChandraSrinivasan

    Perform find by matching multiple values in a single field.

    ChandraSrinivasan

      Title

      Perform find by matching multiple values in a single field.

      Post

      I would like to create a "search / find" based on the matching a set of values in a single field, i.e. EPCC_code in my database (see link below). There are two major search categories: 'Diagnosis' and 'Procedures'. Please ignore 'Procedures' for now. For example under Diagnosis, "EPCC_code = "01.01.01", "04.08.05" Please use the link below to the database that I have created. I have been hearing about using "constrained found set" or "extended found set". But I don't have the skills to create what I am trying to achieve. It took me some effort to get to where it is now. Any help in this would be deeply appreciated. Thanks.

      https://drive.google.com/file/d/0B9279vGVQ4AFWnJrMUNTRXY1c0E/view?usp=sharing