it's not clear just what you're trying to model. are you tracking diagnoses
and medications separately, as data directly linked to a specific patient
and office visit? or are the diagnoses linked to a specific patient/office
visit, and each medication in turn linked to a specific diagnosis? or the
opposite:  the medications linked to a specific patient/office visit, and
each diagnosis in turn linked to a specific medication?

you need to clearly define the "real-world" relationships between the data
you need to store, before you can create a table structure to correctly
model those relationships. if you're not familiar with table
normalization/relationships, suggest you browse the following link:

http://www.ltcomputerdesigns.com/JCReferences.html

if you've already studied normalization concepts, suggest you post an
explanation of what you're trying to "do" with your database, so we have a
better idea of what suggestions to offer.

hth

Hello,

Recently, http://extremedesigners.5u.com - A website about web designing -
has been launched. I would like you to take a look at it and pass your
suggestions - complements - about it.

- Regards,
 Extreme Designing Team.