Question about table design

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

Hello -

I am trying to set up a table that includes numerous
codes, titles and descriptions. Would it be best to
separate this into three tables or leave it as one table?
Would you be able to tell me how to set it up (for
example, primary key, fields in the table(s), etc..?

Thanks for your help!

Carol
 
Generally you can use one code table assuming each code
has a category, code and description. Your table would
have a primary key, usually an autonumber. A code type or
category, the code itself and the description of the code.

If codes are not duplicated between code types, then the
code can be the primary key. With such a table, you can
store the primary key value in your main table and then
get the code and/or description via a join. To use the
code table in a combo or list box, just filter the Row
Source on Code type.
 
Back
Top