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.
lis0122@msn.com wrote:[color=blue]
> 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!
>[/color]