Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    6

    Unanswered: Using one lookup table for multiple tables

    Hi:
    I'm a newbie using Microsoft Access 2003. I have several tables in my database that require "country" as an input. I created a lkup tbl with two fields "CountryID" (autonumber PK) and "Country" (text). I'm using the lkup tbl to prevent users from making mistakes (spelling or otherwise) when entering "country" in the associated tables. Is it bad database design to have all of the tables that use "country" as a datasource refer to this one countrylkup tbl, or should I set up a separate Country LkUp tbl for each table that requires country data input. Thanks for your help!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    One look up table is all you need (or want).

Posting Permissions

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