On Mar 7, 10:16 am, "frank.van.bor..._at_gmail.com"
<frank.van.bor..._at_gmail.com> wrote:
> 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".
lookup is a table for multiple domains (due to values being shared by
multiple tables).
Received on Wed Mar 07 2007 - 11:03:45 CST
