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

    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
    New Zealand
    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

    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

    See clear as mud

    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  3. #3
    Join Date
    Jan 2011
    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