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

Prospects and Customers tables

P: 2
I am a bit new to creating databases so hope this question is not too silly. I am producing an Access (2007) database for my boss, he wants prospects and customers information. Do I create one table for both? I wonder - if prospects have their own table and then a prospect buys something, how do you get them on the customers table or do you have one table for both. Up until now I have only ever worked with one flat table with check boxes for each tpye of contact. I hope this question is not wasting your time but I cannot find an answer I also am trying to learn the terminology so if the answer is already here I apologise. Help here would be much appreciated.
Sep 15 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
I am a bit new to creating databases so hope this question is not too silly. I am producing an Access (2007) database for my boss, he wants prospects and customers information. Do I create one table for both? I wonder - if prospects have their own table and then a prospect buys something, how do you get them on the customers table or do you have one table for both. Up until now I have only ever worked with one flat table with check boxes for each tpye of contact. I hope this question is not wasting your time but I cannot find an answer I also am trying to learn the terminology so if the answer is already here I apologise. Help here would be much appreciated.
Generally speaking, you create one table to hold common information, and use either flag fields, or a link ID to another table that would hold a "Type". So you have a table with person type info in it..and that person can be a customer OR a prospect or a buyer, etc... And all you store is the numeric value of the ID number in the Type table.

check out the template reports that come with Access. You might find a ready made database that doesn't require a lot of changes.
J
Sep 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.