Re: Tracking Customers

["Chris Travers" <..hidden..>]

On 1/26/07, Charley Tiggs <..hidden..> wrote:
> Chris Travers wrote:
> > As I think about it, it might be useful to have a phone field too for
> > main corporate numbers.  But this could be added as a custom field.
>
> Actually, if we're talking about tracking customers, I think phone
> should not be a custom field.  It should actually be a child table of
> the company table.

Looks like I forgot the company_id field in the contacts table.  The
contacts table would be the place where these phone numbers would be.

I was thinking that, in addition to the phone numbers of specific
contacts, companies often have a main corporate switchboard number
which may be different from any DID numbers used by contacts.  This
may be useful to store and might need to be added.  But I am not sure
if this is universally useful or would just add clutter to the data
entry screens for most folk.

Best Wishes,
Chris Travers