Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008

    Unanswered: What fields should I use iin a relationship


    There is a little background to this question in my first thread found here

    If you read that you'll see the schema I'm using and that I'm making a relationship change. But I'm not sure what fields to involve in the new relationship.

    These are the relation ships as they currently are:
    Click image for larger version. 

Name:	relationships.JPG 
Views:	31 
Size:	25.4 KB 
ID:	9120

    And I'm proposing to relate the Log table to Staff_on_project by a combination of the staff_id and project_id fields, instead of linking the Log table directly to project.

    Does this sound right?

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    The primary keys need to match up to your two foreign keys (project_id and staff_id).
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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