Here is my latest dilemma,
I'm designing a table for my pharmacology class that will allow me to
organize the drugs we must know according to the diseases that they
will treat. I want to develop a table that shows all the pertinent
aspects of the diseases, and the drug classes that will treat it with
examples of prototype drugs, side effects, drug/drug interactions and
contraindications, all in one place so that for each disease I'm
trying to remember, I can pull up all the ways to treat it, how they
work and things to remember about each. Many drugs can be used for
multiple roles however.
In BASE, I've found that if I have a field called "associated
diseases" and I enter in "hypertension" and then I enter in
"depression" so that for this record, the entry in the field looks
like "hypertension, depression", what that means is this drug may be
used for either depression or hypertension. If I then setup my query
to do a parametrized query (":which_disease?") it won't return any
results if I enter in only "hypertension" OR if I enter in only
"depression" or if it does, only records that have one string listed
but not both. I'd have to enter in the exact contents of the field as
"hypertension, depression". So I'd have to create queries for each
disease process and then duplicates for drugs that do both.
Does a way exist to tell the query to search through the field, and
display all records that have the term "hypertension", irrespective of
if it also happens to have "depression" along with it?
I guess what I'm trying to do is "tag" my records.
Thanks in advance for any help.
--
Patience yields far greater results than brute force or rage ever
could so relax......it's just life !!!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
