Re: I'm just getting started an I have some questions on tables.

Also a contact with a company can be a customer as an individual.

Marc

"Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
news:5ufee.4063$7F4.472@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
> > >
> > >
> >
> >
> >
>
>


.

Relevant Pages

  • Re: Im just getting started an I have some questions on tables.
    ... >> have a separate contact table for companies and individuals with a ... >>> individuals but both the company contact sub form and the individual ... The first question ... >>> Marc ...
    (microsoft.public.access.gettingstarted)
  • Re: Im just getting started an I have some questions on tables.
    ... duplicate company names but maintain the individuality of each location. ... >>> individuals but both the company contact sub form and the individual ... The first question ... >>> Marc ...
    (microsoft.public.access.gettingstarted)
  • Re: best way to learn.... any learning tips?
    ... to reason with the guy, ... The fact is, you can't play at all douglas, so you play this dingleberry ... it really doesn't matter what he says today because the day after tomorrow he'll announce he was just playing you and you didn't get the black humor blah blah blah. ... my efforts is a look into a mind in which reality is whatever Marc says it is and nothing is *ever* Marc's fault. ...
    (alt.guitar.amps)
  • Re: Homo & molluscs
    ... Any reason why you think these animals could not have lived next to ... >> No reason at all Marc. ... > stressed the probability that the fossils were found near some lake... ... NEARER the small bodies of water than lakeside. ...
    (sci.anthropology.paleo)
  • Re: skinny runners
    ... you're arguing with someone singularly immune to reason. ... >> just in case you actually thought Marc could change his mind, ... Algis displays many if not all of Marc's reasoning, ...
    (sci.anthropology.paleo)