I have created an Inspection Database for our Safety Department and am in the process of remaking it to correct some things you don’t do when creating a database (like using the word date as a field name) along with adding some new features.
Somewhere along the line this database has had the need of exporting open findings so that our project controls department can put these items on a schedule. The problem we have ran into doing this is that each Inspection Number can have multiple findings causing a problem for the program (P3) project controls uses since each item needs a unique number. It has also caused the Safety Department some troubles trying to figure out which of the findings project controls assigned what number too (they keep track of the project controls number in the database now too).
I have considered adding a field so that the person entering the inspection into the database can assign a number to finding, but they have a hard enough time trying to remember what fields need to be completed and how (OK they are not exactly computer gurus). I need a better solution.
What I would like to be able to do (and I don’t know how) is to be able to have it like an auto number, but that the number would start over at 1 for each new inspection number. So, I could have something like:
Inspection Number Finding Number Finding
100 1 Safety Glasses not worn in the PAS
100 2 Safety Glasses not worn in the MDB
101 1 Employee not carrying M40
102 1 Employees not wearing seatbelts in vehicles
102 2 Fire Extinguishers not inspected in the upper modules.
When the report would be given to project controls they would see:
100-1 Safety Glasses not worn in the PAS
100-2 Safety Glasses not worn in the MDB
101-1 Employee not carrying M40
102-1 Employees not wearing seatbelts in vehicles
102-2 Fire Extinguishers not inspected in the upper modules.
How would I automate the Finding Number so that it would start over at 1 for each new Inspection Number?
Thanks in advance for your help,
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net
Somewhere along the line this database has had the need of exporting open findings so that our project controls department can put these items on a schedule. The problem we have ran into doing this is that each Inspection Number can have multiple findings causing a problem for the program (P3) project controls uses since each item needs a unique number. It has also caused the Safety Department some troubles trying to figure out which of the findings project controls assigned what number too (they keep track of the project controls number in the database now too).
I have considered adding a field so that the person entering the inspection into the database can assign a number to finding, but they have a hard enough time trying to remember what fields need to be completed and how (OK they are not exactly computer gurus). I need a better solution.
What I would like to be able to do (and I don’t know how) is to be able to have it like an auto number, but that the number would start over at 1 for each new inspection number. So, I could have something like:
Inspection Number Finding Number Finding
100 1 Safety Glasses not worn in the PAS
100 2 Safety Glasses not worn in the MDB
101 1 Employee not carrying M40
102 1 Employees not wearing seatbelts in vehicles
102 2 Fire Extinguishers not inspected in the upper modules.
When the report would be given to project controls they would see:
100-1 Safety Glasses not worn in the PAS
100-2 Safety Glasses not worn in the MDB
101-1 Employee not carrying M40
102-1 Employees not wearing seatbelts in vehicles
102-2 Fire Extinguishers not inspected in the upper modules.
How would I automate the Finding Number so that it would start over at 1 for each new Inspection Number?
Thanks in advance for your help,
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net
![[wavey]](/data/assets/smilies/wavey.gif "[wavey] [wavey]")
