Jim Lawrence
accessd at shaw.ca
Wed May 9 19:37:06 CDT 2007
Hi Jim: Comments inline... >A. Have a table for every possible type of contact? > >or > >B. Have one contact table which includes a contact "type". There must be a fixed list of contract types so one table should be enough with a key of each "type" code. > and the second question; how do you handle companies vs. individuals and >link the two? Do you: > >A. Have a separate table for companies. > >B. Have a flag which indicates if the contact is a company or an > individual and self-join to your single table. Set the relationship from 'Company' to 'Individual'. The relationship can be standardized by placing a dummy value of "Selfxxxx" in the company field if the individual does not work for a Company Jim