Help!

Need Help with Tbls

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Table Design RSS
Next:  ddddddddddddddddddddddddddddd  
Author Message
TotallyConfused
External


Since: Aug 19, 2005
Posts: 47



PostPosted: Thu Jul 30, 2009 9:31 am    Post subject: Need Help with Tbls
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

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
Back to top
Fred
External


Since: Jun 26, 2006
Posts: 84



PostPosted: Mon Aug 03, 2009 5:31 am    Post subject: RE: Need Help with Tbls [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Table Design All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum