I'm trying to set up database for a medical study. I need to have a column that is for past medical history...I want to be able to click on the cell and have a drop down tab which shows me a list of diseases. I need to be able to click on multiple disease but have them show up only as numbers to make the stats easier... For example, Diabetes =1, High Blood Pressure =2, stroke=3 etc... So if patient x has both diabetes and hemorrhage the column would show 1,3.

In addition, depending on which diseases are chosen there may be associated questions specific to that disease. So for example, if stroke=3 then the a popup box (?) which forces you to enter the patient's stroke score (numerical format), and 2 Y/N questions related to intervention would be next.