Drop down boxes on forms

[Susie]

I have had a request from my co-workers to change a
database that somebody else created and I need to know if
this will be complicated. It is a database containing
medical record numbers and visit numbers. Some medical
record numbers are attached to more than one visit. What
they want is to type the medical record number in the
form, have the patient demographics load and also, have a
pop up box with visit numbers associated with that medical
record number so they can choose the vist number they are
interested in. I am somewhat horrified as I have never
done anything like this before and, they want it done
yesterday. Where should I start??

 

[Matthew]

That won't be difficult. Please post the table
structure/fields for the relevant tables.I assume that
medical records are in one table and visit details are in
another - and therefore it is a simple matter of producing
a form with a subform based on the one-to-many
relationship of the medical number to the visits table.


Matthew