Table Design Question

Results 1 to 2 of 2

Thread: Table Design Question

  1. #1
    Hariu Guest

    Default Table Design Question

    I am building the tables for a Access Database. Seven of those table share the userID row name. Is it good practice to have Seven tables link back to one primary key in my user table?<BR><BR>Suggestions?

  2. #2
    Jason Miller Guest

    Default RE: Table Design Question

    Yes. If a group of tables will be referencing an identity, that identity should be registered as a foreign key in each table.<BR>Note that this is a "should" situation, not a "your users will curse your name, your DBA will burn you in effigy and your server will spam your email address!" situation. It&#039s just a good practice to tell the database about relationships between tables.<BR>

Posting Permissions

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