A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need Help with Tbls



 
 
Thread Tools Display Modes
  #1  
Old July 30th, 2009, 05:31 PM posted to microsoft.public.access.tablesdbdesign
totallyconfused
external usenet poster
 
Posts: 304
Default Need Help with Tbls

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

  #2  
Old August 3rd, 2009, 01:31 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Need Help with Tbls

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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.