lookup tables

[DTSFreak]

Hello,

I was wondering what the best way is to use lookup tables. i don't want to use a new table for every lookup.

Basically what i want is a generic lookup table for all kinds of data. In queries, to translate the integer value of the lookup, it should know which description it should use in the lookup table.

Anyone knows a solution?

 

[johnherman]

Sometimes basic code tables are combined into a generic code table. For example

Codes
CodeTableName
CodeValue
CodeDescription

sample data
GENDER
M
Male
GENDER
F
Female
GENDER
U
Unknown
MARITAL STATUS
M
Married
MARITAL STATUS
S
Single
MARITAL STATUS
U
Unknown

etc

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright