I just finished up a payroll program in Access (thanks to those who helped me there), and now I'm working on my last project, keeping track of our services: well drilling and pump installation. I'll explain a little about us first. We're a non-profit operating in Zambia drilling wells, installing pumps *and* repairing broken pumps. So we have a lot of information to keep track of.
What I want to accomplish is this:
Keep track of wells drilled
Keep track of pumps installed
Keep track of pumps repaired.
The following scenarios can happen:
1) We drill a well and install a pump. <--- Normal
2) We drill a well and don't install anything. <--- rarely
3) We repair an old handpump, so no well drilling here. <--- we will have many of these to do soon.
It would be amazing to be able to enter the data for a well, and later, enter the data for the pump and have the two be joined somehow, as a relationship. I have thought of some things that might make this easier:
Well Serial Numbers and Pump Serial Numbers (Purely fictitious numbers, only in the database) that could have a format like this... WFTO-2009-W-0001 where "W" mean well and 0001 is auto-incrementing. That way, we could also separate them by year without much more work (in a drop down list?)
I am open to any suggestions you may have. If you would like the sample database, I'll upload it to my website, as I can't attach Access 2007 files here.
