Topic: Match Tablegrid with Combobox
Hi everyone.
(This is gonna be hard to explain.)
I'm working on a project regarding Antibiotics taken by patients in a hospital.
There are 1000 patients and 30 different antibiotics.
The antibiotic types are recorded using a combobox as you can see the attached sample.
What I need to do is that when I search patients' names, all the medicine info (number , price and antibiotic types) that he took as well as those he did not take are shown in a tablegrid (if he didn't take that antibiotic , the related cell should be left blank.) and all of these info should be shown in just one row of the tablegrid
the antibiotics should be ordered alphabetically for example in the tablegrid (search form):
the first row is First name (Jack , Eva , ...)
the second row is Last name
the third row is Medicine Type ( only azithromycin)
the forth row is number ( the number of azithromycin that the patient took and if the patient did not take any of that pill this row should be left blank or Zero)
the fifth row is price ( the price of that specific antibiotic and again if the patient did not take any pill this row should be left blank or Zero)
the sixth row should be Medicine Type (only ampicillin )
the seventh row is number
so on and so forth (Please see the attached picture and hopefully you will understand what I Mean)
guys this is not for aesthetic purpose this is because I need to know which pills a patient did not take and compare it to other patients with similar diseases who took that specific antibiotic so similar antibiotic for different patients should be in the same column of the tablegrid.
if you have any other approaches feel free to share
thank you guys you have helped me a lot with my project