[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Tracking Customers

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