russellobrien
Programmer
Dear All,
I am developing a simple pharmacology database. I have an Access DB with a list of drugs, list of drug classes and a list of class to class interactions.
What I wish to achieve is to put a list of drug classes into a query (say 5 or 6) and then return a list of all the interactions pulling in the name of the class from its table based on the ID stored in the interaction table.
I think using IN twice for each class may work, but this will presumably produce duplicates especially of the same class.
Any elegant (or non-elegant) solutions appreciated!
Russell
I am developing a simple pharmacology database. I have an Access DB with a list of drugs, list of drug classes and a list of class to class interactions.
What I wish to achieve is to put a list of drug classes into a query (say 5 or 6) and then return a list of all the interactions pulling in the name of the class from its table based on the ID stored in the interaction table.
I think using IN twice for each class may work, but this will presumably produce duplicates especially of the same class.
Any elegant (or non-elegant) solutions appreciated!
Russell