Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    27

    Unanswered: Table Design Issue, Junction or Not?

    In this issue, I have three tables, Work, People, and JunctionPeopleJobTitles as seen in the attached pic. It might be helpful to know the junction table connects to a JobTitles table. Its function is to use the person as they were in a point in time since people get promoted and whatnot.

    I originally did not have dates attached to the work and had PeopleFK. Then I found dates to be easy to attain, so I broke off the People relationship and connected it to the junction table. As I did, I then found that I could attach a person in time to the work. I had been running Excel VBA for now to find what a person did when the work unit was done.

    Now I found that a query can find the same data on-the-fly. I might have just answered my question, but are there any other issues to think about? The Work table is over 180K records and is the crux of the database. I will have to run the query for nearly everything.
    Attached Thumbnails Attached Thumbnails junctionIssue.JPG  

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,472
    Provided Answers: 10
    and Idea he could be a bit late

    this mite make easier

    what i do

    name the PK the same name as the Table

    Customer Table
    CustomerID <= PK
    ...
    ...

    then in the Invoice Table
    InvoiceID
    CustomerID
    ....
    ...
    ...

    so just by look at the table I can see how it is link to and other table

    also what msaccess does if create a query with those to table it will put the link in for you.

    its what I do
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jan 2011
    Posts
    27
    Yes, that was one of the early tables, and I regret not keeping the normal naming scheme for that table like you describe. Thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •