Dugantrain
I Love Pants
- Local time
- Today, 02:49
- Joined
- Mar 28, 2002
- Messages
- 221
I have a database that I'm having a rough time with setting up the tables. The database is based off of a spreadsheet which has now been determined antiquated. Here's what is going on:
25 techs go out daily with a kit full of parts. When they get to a site, they use certain parts from the kit (there can be more than one of each part in a kit). They may also pick up parts and add it to the kit, but will not go over a pre-determined maximum. Each part type has a serial # which is unique only to that part (again, there can be several serial #'s for the same part type, i.e. if you have three printers in your kit, then you'll have three serial numbers). When a tech leaves a part at a site, a serial # needs to be deleted from the database; when he picks up a part, one needs to be added.
I have a table with tech information (25 records, unchanging, this was easy). I have a table for Parts (Part Type, Recommended # in Kit, Description). I still need to set up tables so that I can get a running summary of:
*How many of each part type was added to the kit that day
*How many of each part type was subtracted that day
*How many of each part type is currently in the kit
*How many of each part type the tech is short for the maximum.
*Serial numbers for each part type
Please, please Help!
25 techs go out daily with a kit full of parts. When they get to a site, they use certain parts from the kit (there can be more than one of each part in a kit). They may also pick up parts and add it to the kit, but will not go over a pre-determined maximum. Each part type has a serial # which is unique only to that part (again, there can be several serial #'s for the same part type, i.e. if you have three printers in your kit, then you'll have three serial numbers). When a tech leaves a part at a site, a serial # needs to be deleted from the database; when he picks up a part, one needs to be added.
I have a table with tech information (25 records, unchanging, this was easy). I have a table for Parts (Part Type, Recommended # in Kit, Description). I still need to set up tables so that I can get a running summary of:
*How many of each part type was added to the kit that day
*How many of each part type was subtracted that day
*How many of each part type is currently in the kit
*How many of each part type the tech is short for the maximum.
*Serial numbers for each part type
Please, please Help!