Searching for specific text in a memo field using InputBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm developing a Db which stores medical information, including allergies. I
would like to search for specific text in a memo field by having the user
input which allergy to search for using an InputBox. I then need to display
all people who have that specific allergy.

Thanks for any help in advance.
 
Just one thing to add: Not using a memo field isn't going to work: there are
too many possible combinations.
 
Jabutron,

Poor design; memo fields holding several data each won't get you very
far! Patients - to - allergies is a classic many-to-many relationship,
and should be dealt with as such, i.e. through the use of a "resolution"
table. So, your design should involve:

1. A Patients table with a PK field, say, Patient_ID, plus any other
data (name, address, sex, DOB, ... whatever).

2. An Allergies table with a PK field, say, Allergy_ID

3. A PatientAllergies (resolution) table, including both PK fields from
the other two tables. In this table, there will be as many records per
patient as the allergies recorded for that patient; likewise, there will
be as many records per allergy as the patients recorded having it.

Following that, identifying all the patients with a partivular allergy
is just a question of a query on the PatientAllergies table.

HTH,
Nikos
 
Back
Top