dinamic table

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

Guest

I am trying to create a dinamic table for drug interactions, and need to add
comments in each interaction.
Could anybody help me to create it?
thanks
 
I am trying to create a dinamic table for drug interactions, and need to add
comments in each interaction.
Could anybody help me to create it?
thanks
Click to expand...

Not sure what *you* mean by a "dynamic" table. Speculating here, I'd suggest
that a database recording drug interactions needs at least two tables: Drugs
and Interactions. For example you might have:

Drugs
NDCCode <Primary Key> <or appropriate unique identifier, like CAS Reg>
GenericName
TradeName
<any other info about the drug as an entity>

Interactions
Drug1Code <link to NDCCode>
Drug2Code <link to NDCCode>
NatureOfInteraction
Severity
<etc etc>

John W. Vinson [MVP]
 
Back
Top