S
SteveG
Hi. I'm trying to create a form in Access 2003 to enter data about
the kinds of assistance patients need -- dressing, washing and so on.
Patients will typically need assistance with more than one thing.
I've got a tblPatients, with PatientID as the primary key, a lookup
tblAssistanceType, with AssistanceTypeID as the primary key and a text
field for the type of assistance, and tblPatientsNeeds, which stores
PatientID and AssistanceTypeID, with one row for each type of
assistance a patient needs, on the lines of Customer, Order and
OrderDetails. First question -- should I be doing it this way?
Second queston. Assuming I should be doing it this way, if I put an
unbound list box that allows multiple selections, populated with a
query selecting the records in tblAssistanceType, on a form, bound to
the main form on PatientID, how can I get my multiple selection into
tblPatientsNeeds all in one go?
Can I somehow write an append query that runs when I click a button,
takes the AssistanceTypeIDs off the list and puts them into
tblPatientsNeeds? Or is there a better way of doing it? I'm afraid
I don't know much about Visual Basic.
the kinds of assistance patients need -- dressing, washing and so on.
Patients will typically need assistance with more than one thing.
I've got a tblPatients, with PatientID as the primary key, a lookup
tblAssistanceType, with AssistanceTypeID as the primary key and a text
field for the type of assistance, and tblPatientsNeeds, which stores
PatientID and AssistanceTypeID, with one row for each type of
assistance a patient needs, on the lines of Customer, Order and
OrderDetails. First question -- should I be doing it this way?
Second queston. Assuming I should be doing it this way, if I put an
unbound list box that allows multiple selections, populated with a
query selecting the records in tblAssistanceType, on a form, bound to
the main form on PatientID, how can I get my multiple selection into
tblPatientsNeeds all in one go?
Can I somehow write an append query that runs when I click a button,
takes the AssistanceTypeIDs off the list and puts them into
tblPatientsNeeds? Or is there a better way of doing it? I'm afraid
I don't know much about Visual Basic.