I'm not sure the best way to achieve what I need. I currently use excel for this and it's become a workbook with over 100 sheets and takes forever to load.
We are a construction company, we have to call in to OKIE811 to notify them of our intent to do work that could interfere with utility companies lines/pipes etc so that they will then notify the companies in that area and those companies will mark their lines so we don't hit them. The ticket reference numbers we are given are only good for 10 days, then we have to update and get a new 14 digit ticket number. I have some tickets that have been active since 2015 so there are a lot of those 14 digit numbers. In addition to that, the StartDate StartTime UpdateByDate and ExpirationDate change every week also. And the contact for the ticket can change as well as different crews doing different things go to take care of their part of the job.
I do need to have these previous ticket numbers, it's the only way to know precisely which ticket the responses are for. I just need some advice on how i should go about this.
I've started the database breaking apart the main DATATABLE into parts that reduce some of the redundancies (Caller info, contact info, excavator info, etc).
I've attached a very small part of the original excel workbook that I use for reference. This is just a small part of it. I deleted most of the table rows and cover page sheets because it was such a large file.
The columns highlighted red can change each week. Each job can have more than one locate as well.
Any help on this would be very appreciated.