In the database I am working on, I have a form that records the serial numbers of pages or forms in a book. For instance, a book might have pages 001201 to 001300. These numbers are unique and no two similar types of books or forms will have the same series of numbers. I also have a start and end date for each book or series, which I use to indicate if the book is in use, has never been used, or is used and finished.
Every so often, there is an inspection of these books to ensure accountability. At this time, I need to be able to identify those books currently 'in use' and input another entry indicating what serial number the book is up to at the time of the inspection. This serial number may change from inspection to inspection, and I just need the information from the latest inspection. Once a book is completed (indicated by the 'end date' field being completed), this information is no longer needed, just the start and end serial numbers and start and end dates.
What I am after is any ideas on the best way to tackle this, i.e. hide/unhide the additional serial number under particular conditions. I have tried a couple of methods using code but get errors advising that particular records cannot be saved.
Also, with the above scenario, is it necessary to save this additional serial number in my table or can it just remain in limbo until changed or is no longer needed.
Any pointers would be appreciated.
Every so often, there is an inspection of these books to ensure accountability. At this time, I need to be able to identify those books currently 'in use' and input another entry indicating what serial number the book is up to at the time of the inspection. This serial number may change from inspection to inspection, and I just need the information from the latest inspection. Once a book is completed (indicated by the 'end date' field being completed), this information is no longer needed, just the start and end serial numbers and start and end dates.
What I am after is any ideas on the best way to tackle this, i.e. hide/unhide the additional serial number under particular conditions. I have tried a couple of methods using code but get errors advising that particular records cannot be saved.
Also, with the above scenario, is it necessary to save this additional serial number in my table or can it just remain in limbo until changed or is no longer needed.
Any pointers would be appreciated.