On Thu, 2004-05-20 at 07:13, Lewick, Taylor wrote:
> Hi all, I am having a little trouble deciding how to relate some of my
> tables together.
>
>
>
> I was wondering about creating one big lookup table to relate 3 or 4
> tables together, but wasn't sure if that was a good id, or should I have
To simplify, is It better to have many smaller lookup tables or one big
one?
Traylor:
You can create three entity tables (organization,contact,event) + the relation
tables (org_contact, org_event, contact_event). Small lookup tables are usually
better, and also give you points for sticking to
