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 a normalized design.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]