Need Help with Tbls

[TotallyConfused]

I have db that I am having trouble with and believe it has to do with my
tables. Below are my tables. I tried as best as I could to split an Excel
Flat file. Would I have to have different tables for all the items below in
parenthesis? For instance, MKT maybe there are only 3 market names, would
that warrant a whole separate table? If so, I would only have two fields
Market Name and ID (it would have to be an autonumber ID for PK). Then how
would I link or add this MarketID into another table. Sorry for being so
anal but I am trying to understand all this. Thank you for any help you can
provide.

tblHOSFXs (this table is a one to many to the tblContrNum)
DocID - PK
Date Sent
Date Due
Date Rcv
etc.

tblContrNum (this is a many to many to all other tables)
ContrID - PK
DocID - PK
PTID - PK
Mkt (there are different mkts)
DTClosed
Flag (there are different flgs)
INS (there are several ins type)

Doctors (one to many to ContrNum table)
DocID - Pk
DocNM
DocPH
DocFX
DocAdd
DocAdd2
DocCity
DocSt (different sts)
DocZip (different zips)
DocCnty (different counties)
etc

Patient (one to many to ContrNum table)
PtID - PK
PT DOB
PT LNM
PT FNM
PT MailSent
PT MailRcv

 

[Fred]

I noticed that nobody answered. Your problem in your approach may be the
same one in your post.....you completely skipped over the important stuff.
Turn the computer, Excel and Access off and start by making a list of the
real world entities that you want to database, and of any relationships
between those entities, and then decide your entity situations (One to one,
one to many, many to many) on each side of those relationships. Then design
your table structure from that list, or tell us about if so we can help.