Lists that opop up when a box is checked

[Guest]

I am still working on my patient database. I have a section that relates to
medication types. If a patient is using a certain type such as Inhaled
Corticosteriods there is a check box to mark that medication type. Now I need
to add a list of the particular medications such as Advair, pulmicort,
flovent and so on; and then another list to note dosage such as 100/50, 220
mcg, and so on.

The other thing is when I am doing a guery I would like to be able if
necessary to guery not only the type of medication, but also the actual drug
and dosage.

Shirley McCullough

 

[Guest]

You could try adding a combobox of medicines and setting its visibility
according to whether or not the checkboxbox is checked (i.e.
CheckboxOnAfterUpdate: ComboBox.visible = Checkbox). This combobox would then
also allow entry of the medication type onto your patient table

HTH

Chris