View Single Post
  #1   Report Post  
Marc
 
Posts: n/a
Default I'm just getting started an I have some questions on tables.

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