AnsweredAssumed Answered

Perform find by matching multiple values in a single field.

Question asked by ChandraSrinivasan on May 30, 2015

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

 

Outcomes