Question about table design

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
 
S

SBD

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top