query criteria

[Dave]

One of the things I need to build into my database is to search for
all instances of antibodies that match antigens.
Some of these antigens however, are "broad" category. That is, for
example, B12 can be B44 or B45. Cw3 can be Cw9 or Cw10. There are many
of these broad category examples.

So I'll build a query that uses the input into a text box as the
search criteria. If someone enters B12 into the control, I need the
query to return B44's or B45's. If they enter A10, the query may need
to return A25, A26, A30 and so on. What is the best way to do this? Or
does something need to be built at the table level?

Thanks in advance,

Dave

 

[John W. Vinson]

One of the things I need to build into my database is to search for
all instances of antibodies that match antigens.
Some of these antigens however, are "broad" category. That is, for
example, B12 can be B44 or B45. Cw3 can be Cw9 or Cw10. There are many
of these broad category examples.

So I'll build a query that uses the input into a text box as the
search criteria. If someone enters B12 into the control, I need the
query to return B44's or B45's. If they enter A10, the query may need
to return A25, A26, A30 and so on. What is the best way to do this? Or
does something need to be built at the table level?

Thanks in advance,

Dave

The information that a B12 is a superset of B44 and B45 needs to be encoded
*somewhere* so Access can get at it, and a table is the natural place to do
so.

I'd suggest (at least) a table with two columns, Broad and Narrow, with each
"broad" antigen paired (in different records) with all its "Narrow" mates.
This table can be used in conjunction with the combo box to select all the
appropriate values.

 

[Dave]

The information that a B12 is a superset of B44 and B45 needs to be encoded
*somewhere* so Access can get at it, and a table is the natural place to do
so.

I'd suggest (at least) a table with two columns, Broad and Narrow, with each
"broad" antigen paired (in different records) with all its "Narrow" mates..
This table can be used in conjunction with the combo box to select all the
appropriate values.
--

             John W. Vinson [MVP]- Hide quoted text -

- Show quoted text -

Thanks John,

I knew I could count on this group for good ideas!

Dave