Contact Management

[Confused]

I'm new to Access and having problems with creating a Contact database. I
have a list of companies that are assigned to differnt people as in a module.
Steve has 50 customers, Joan has 75 etc. I'm wanting to take this list and
add contact information, such as email addresses for these customers. How is
the best way to do this where e.g., Steve can click to show only his
customers and readily see the contacts in a tabular format that are missing.
And then what would be the easiest way to add the contacts. I need to be
able to add multiple contacts per company. General guidance would be
appreciated.

 

[Arvin Meyer MVP]

I'd build a database with at least 4 tables:

Customers

CustomerDetails

Contacts

ContactDetails

Representatives

CustomerDetails are the various offices for your customers together with the
specific addresses, etc. of those offices.

ContactDetails are the various addresses phone, cell, email, and fax
numbers.

Representatives are your reps that manage the Contacts.