Hi guys,

Hopefully this hasn't been asked yet. I am constructing a research database to track patient outcomes. The focal point of the database is the operations table, where patient survey scores are entered at specific intervals. Patients fill out surveys pre and post operatively to measure general health improvements. There are also tables for diagnosis and procedures, which are linked to the operations table through a joining table. A portal for each resides in the Op table. Now for my question...

Each operation can be based off of multiple diagnosis and procedures. I need a way to perform a find for operations that have specific diagnosis and procedures, while omitting everything else. Lets say there are diagnosis A-Z and procedures 1-10. I need the ability to filter out operations with a diagnosis of A,D, and F, with procedures 1,5, and 10 peformed, while excluding everything else. I can then export the scores and look at the efficacy of specific procedures based on specific diagnoses.

Hopefully that makes sense!

Thanks, Ryan

Duplicate of this post:

http://www.fmforums.com/forum/showtopic.php?tid/214505/fromactivity/posts/

Anyone? This is probably the last component of the database needed for it to be fully functional. :

Any help is greatly appreciated, really struggling with this....