Re: I'm just getting started an I have some questions on tables.
- From: "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com>
- Date: Thu, 05 May 2005 02:25:05 GMT
The reason for the company/customers was having all the contacts - people -
in the customer table. Otherwise I'm going to have both in the same table
that seems awkward to me.
Marc
"Mike Revis" <mike@xxxxxxxxxxxxxxxxx> wrote in message
news:117is8g6chcrgc5@xxxxxxxxxxxxxxxxxxxxx
> Just a thought here but how about treating both companies and individuals
as
> the same type of entity. i.e. "customers" or "people and companies I want
to
> keep track of".
> You could then have one table for "customers" and have a field for "type"
in
> which you could select either business or individual. Your contact table
> would then contain the contacts at either the company or individual.
> If the type and amount of contact data you are collecting for companies is
> greatly different from the contact data collected for individuals you
should
> have a separate contact table for companies and individuals with a
separate
> data entry form for each. Which contact form to open could be determined
by
> the entry in the "type" field.
>
> Mike
>
>
>
> "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> news:ytaee.5225$V01.4442@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > I deal with both companies and end users and I'm trying to figure out
how
> to
> > set up the contact table. My plan was to set one table for companies
and
> > have contact entries as a sub form and another form for contacts with
> > individuals but both the company contact sub form and the individual
form
> > would link to the same table? My reasoning is that I may have many
> contacts
> > to one company but have individuals that contacts normally at most would
> be
> > "domestic partners"and their family members and I want to track contacts
> > whether it's email, phone calls, letters and more. The first question
on
> my
> > form would be which kind of contact would I be working with and bring up
> the
> > correct form. I know that this will be the first of many questions.
> >
> > Marc
> >
> >
>
>
>
.
- Follow-Ups:
- References:
- Prev by Date: Re: Open Form Last Record
- Next by Date: Re: I'm just getting started an I have some questions on tables.
- Previous by thread: Re: I'm just getting started an I have some questions on tables.
- Next by thread: Re: I'm just getting started an I have some questions on tables.
- Index(es):
Relevant Pages
|
