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

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
Loading