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

    Unanswered: Using one lookup table for multiple tables

    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
    metro Detroit
    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