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!