On 7 mrt, 02:10, "Timasmith" <timasm..._at_hotmail.com> wrote:
> Suppose I have a database table with 20 fields which are lookups to a
> single table.
>
> configtable(configtable_id, a_field, something_lookup_id,
> another_lookup_id, ...)
> lookup(lookup_id, value, description, ...)
>
Suppose you normalize?!?
make it a table with field, lookup_value.
If you insist on using one table for multiple domains, use
domain_id, field, lookup_value, and set a Primary Key
on domain/field.
You called domain "configtable_id".
Received on Wed Mar 07 2007 - 09:16:45 CST
