Results 1 to 2 of 2

Thread: Need to create foreign key in access 2007

  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Need to create foreign key in access 2007

    Plesae help! I am building a relational database with 2 main tables that should relate in a one to many relationship. I have gone to the design tab created relationship, done the join but cannot enforce referential integrity.

    The database tracks managers and their accounts. ONe table tracks managers and the subtable (the many) tracks their accounts.

    Of course there are managers without accounts as yet, but Access will not let me enforce ref integrity saying that managers may have records not found in accounts. Of course that's true.

    Can you please help me set this straight.

    And ultimately, I want to ensure that if I have to delete a manager, I can delete all associated accounts at the same time.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have to fix the data before you can enforce the foreign key reference.

Posting Permissions

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