By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Need some help in designing a simple customer database

P: n/a
I'm creating a mini-CRM system for a couple of our telesales employees.
I have very basic knowledge in Access so bear with me. :) So far I
have three tables...

Contacts (the people to call)
Sales Activity (where call activity is logged)
Topics (product to call for)

I want to be able to continually add contacts to the contact table
around different topics. Contacts can have multiple topics and sales
activities. Then, I want to create a form with Contacts with a subform
of activities for them to input the activites around a certain topic.
How do I link the tables together and what's the best way to create a
form (or multiple forms) that will allow them to log the activity
around the topics? Thanks!

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The heart will be your Sales Activity table. Each record in here will
have one customer -- linked by an ID field to your customer table,
and one sales rep, linked by an ID field to a table of sales reps.

Make your tables first, then make a form from them using the wizards.

li*****@msn.com wrote:
I'm creating a mini-CRM system for a couple of our telesales employees.
I have very basic knowledge in Access so bear with me. :) So far I
have three tables...

Contacts (the people to call)
Sales Activity (where call activity is logged)
Topics (product to call for)

I want to be able to continually add contacts to the contact table
around different topics. Contacts can have multiple topics and sales
activities. Then, I want to create a form with Contacts with a subform
of activities for them to input the activites around a certain topic.
How do I link the tables together and what's the best way to create a
form (or multiple forms) that will allow them to log the activity
around the topics? Thanks!

Nov 13 '05 #2

P: n/a
Thanks for the reply. Where does the Topics (products) table get
linked?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.