From 'Indexing' post I've got the drop-down required showing 'Patients'. 2 things I need from this:
a) Each Patient will have several calculations done and a 2nd drop-down, 'Calc', will be dependent on it. How do you arrange this?
b) I'd like to display 'all', 'current' or 'discharge' patients in the 'Patient' drop-down. How?
c) I'd like to be able to change patient status (current vs discharged) so that it affects all records for a particular patient. How? I assume this must be a separate function to b)?