Should lookup tables have a numeric FK column as well as the description column?
If so, how should I add an FK to the two lookup tables in my database?
Most do (have a surrogate PK) since it removes cascading updates and is a smaller value.
Lots of alter tables and update queries.
David J.
