D
Dave
I am preparing a database that will include tracking of patient
antibodies. There are six classes of antibodies:A, B, C, DR, DQ and
DW. In each class there are about 20 specificities. For each patient
record I want to include both the specificity and its strength and be
able to sort on each parameter. I need to know the most efficient
table structure as with 100's of patients and each patient with a
dozen antibodies or more, this table could get large and unwieldy.
I'm thinking of having a Lookup table for each antibody class and a
table for the antibodies in the patient record. Am I on the right
track here?
Thanks everyone,
Dave B
antibodies. There are six classes of antibodies:A, B, C, DR, DQ and
DW. In each class there are about 20 specificities. For each patient
record I want to include both the specificity and its strength and be
able to sort on each parameter. I need to know the most efficient
table structure as with 100's of patients and each patient with a
dozen antibodies or more, this table could get large and unwieldy.
I'm thinking of having a Lookup table for each antibody class and a
table for the antibodies in the patient record. Am I on the right
track here?
Thanks everyone,
Dave B