Results 1 to 3 of 3
  1. #1
    Shag84 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    18

    An import question above the table structure

    Hello all,

    Iím not sure how to handle the import process. I want to take all data in my Excel spreadsheets and create an Access database so I will be doing a lot of importing. The question doesnít concern the import process but does concern table structure.

    In the process of preparing & normalizing my spreadsheets to be Access ready Iíve hit a conundrum. My spreadsheet headers look something like this:

    Dr Referrals (soon to be tblDrRefs)
    DrName Site1-PT Site1-OT Site2-PT Site2-OT Month Year

    There are actually 5 sites (soon to be 6) and 5 to 6 disciplines. So I broke out the redundant data into their own tables; tblSites, tbldiscipline, tblDrs.

    If I did things correctly my new DrRefs table should look something like this:

    DrRefID DrID SiteID DisciplineID RefDate RefNo.

    So, if the preceding is correct, here is my question: the DrRef table would have three ID numbers from the other tables to identify the doctor, what site it was for, and what discipline it was for (PT, OT, Speech, Cardiac). Do I build my other tables using my own Primary Key ID numbers, then build the DRRef table using those numbers??



    If Iím completely off the mark please let me know.

    Thank you,
    Don

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    As you are recording referral details at patient level, a patient can have many referrals by different doctors for different specialties more than one doctor can refer from the same specialty. So what you want is a child table with a FK back to the patient PK, a FK back to the specialties PK and a FK back to the doctors PK. This way you can have as many or as few referrals as is necessary.

    David

  3. #3
    Shag84 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    18
    Thank you David. I appreciate the help.

    Don

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-15-2009, 04:08 AM
  2. Import XML String into Access table
    By chrisjohns in forum Programming
    Replies: 0
    Last Post: 04-16-2009, 01:47 AM
  3. SQL statment structure
    By oss_ma in forum Programming
    Replies: 1
    Last Post: 05-13-2007, 02:08 AM
  4. Import multiple dbf files into existing table?
    By sbg2 in forum Import/Export Data
    Replies: 0
    Last Post: 06-12-2006, 02:06 PM
  5. Import/Link Pictures into a table
    By shm138 in forum Import/Export Data
    Replies: 3
    Last Post: 03-17-2006, 08:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums