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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|