company with multiple contacts

[JOE POLLOCK]

I currently have one table which contains all my customer information with
all the contact information repeated for each person in that company. I want
to separate it to maintain a main customer form with a subform listing the
various contact people at that company. Any suggestions?

 

[Al Campagna]

Joe,
My suggestion would be to read my reply on 02/11 to this same
question you posted on 2/11 @ 10:25am.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Fred]

Joe,

Answering that fully is more like a very important chapter 1 in a
"relational database design" book than a singel post, but here's a "skeleton"
to guide you.

Make / evolve to the following:

A "Companies" table with fields for all of the "one per company" type
information (address, state etc.) plus an autonumber Primary Key
"CompanyIDNumber" field

A "People" table with fields for of the "one per person" type information
(cell phone number, title etc.) plus an integer (not autonumber, not PK)
field named "CompanyIdNumber" (and join this field to it' snamesake in the
"Companies" table. Now, put the "CompanyIDNumber" of where they work in
each person's record. (the below form will do that automatically for you for
added new people )

Create a form (datasheet style) use the people table as a data source. Name
it "PeopleSubForm"


Make a "one record per page" style form using "Companies" as a record
source. The insert your "PeopleSubform" form into that form as a subform


Again, just a skeletion, the whole "how to' would be 50 times longer, but
ask questions where you get stuck.

Hope that helps.