Hello!
I am trying to create a drop down menu that will let me filter through order types in order to view specific tests that were run. However, sometimes there are multiple tests ordered. I need the database to still show me "HIV, Urine Culture, Pap Smear" when I've selected "Pap Smear" from the drop down menu. I also don't want it to create a new menu option for these multiple listings. I only want a new menu option to be created when I enter a single item. Any help would be greatly appreciated!! Thank you!!
For example, if I added "Blood Draw" to D20, I want that to automatically be added as an option to the drop down menu. But if I were to add "Blood draw, Pap Smear, HIV" I don't want that to become an option. Also, if I selected "HIV" from the drop down menu, I'd want the entry "Blood draw, Pap Smear, HIV" to still appear. I would also want it to appear regardless of whether it typed "HIV" or "hiv" or, for another example, "Pap smear" vs "Pap Smear".
Any and all help is greatly appreciated!! Thank you!!
Bookmarks