dinamic table

M

mel

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
 
J

John W. Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to have two tables on same line? 1
Dinamic Tables 0
VBA Coding Help for Beginner 0
Construct table from selected rows 4
New Bug in Track Changes in Word 365 0
Dinamically modifying a form 1
Code to link external tables 1
how do I add in a dinamic graph the total as a new series? 3

Top