Database quick question - easy one for all you programmers - Beyond me though 
Author Message
 Database quick question - easy one for all you programmers - Beyond me though

Hi, I have to create a program that will track 12 salespeople's sales
stats, and allow for more in the future. It will track 4 constant stats
that are the same for everyone. What I'm wondering, is should I make 12
separate databases??? Would that REALLY slow down the program, or not?
Could it all be combined to one database, and how? Which is the best way?

I plan to use combo boxes to access the salesperson, then fill in text
boxes for stats, and be able to access prior 4, 8, and 12 week totals /
averages. I also want it to print out the order of salesperson figures, the
best on the top, and descending down and print it.

Thanks a bunch!

--
Dave

Remove the "spam" from the address, or use:



Fri, 12 May 2000 03:00:00 GMT  
 Database quick question - easy one for all you programmers - Beyond me though

I would recommend using only one database.  Making 12 different DB's is
a lot of extra work, then what happens if your company hires 20 more
sales people?? Then you got to make 20 more databases!!  Id make one DB,
and set it up somehow (based on the requirments, which i dont have
naturally! =) )  so that each salesperson has a Unique ID (or something
like that)  that identifies him or her, and go from there.  Just relate
each stat to a specific salesperson ID.

--andy



Fri, 12 May 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Quick Database question - Easy one for you experienced programmers, but out my hands - Please help

2. Two questions... one easy, one hard

3. Easy and quick database programing

4. quick and easy question....please help!

5. Quick and easy question:

6. SendKeys - Quick, easy question

7. newby: quick n easy question

8. TabStrip control - quick easy question

9. NEWCOMERS QUICK AND EASY QUESTION.

10. Quick and Easy newbie question

11. A quick, hopefully easy question...

12. Quick easy question for someone

 

 
Powered by phpBB® Forum Software