dinamic table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mel - 28 Mar 2007 00:52 GMT

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

Reply to this Message

mscertified - 28 Mar 2007 16:24 GMT

Yes. What is your specific question?

> 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

Reply to this Message

John W. Vinson - 28 Mar 2007 17:19 GMT

>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

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]

Reply to this Message

Jamie Collins - 29 Mar 2007 14:39 GMT

On Mar 28, 5:19 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

> >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?

Are you aware that such data is commercially available? Here's a
product I've used (UK version) in the past (IMO cost effective when
compared with retaining a pharmacist) or something very similar:

http://www.firstdatabank.com/products/nddf/clinical/drug_drug.aspx

Jamie.

--

Reply to this Message