I have created a document database housing all procedures with approvals, revisions, release date, etc. It tracks past revisions and also links to a training database that assigns training and allows the user to train. The issue I am running into is printing records/tables. I have the app show a list of all released procedures and will display on the print screen to be able to print a hard copy. In testing, everything worked great, as I was only using a handful of procedures. After loading all the current procedures, the screen populates with the list and has a scrolling feature. My assumption was when it would go to print, it would print multiple pages to show the entire list. I was wrong. This would also now apply to training records.
regarding your question, there are several ways to solve this. I’ll suggest one here, but I’m curious to hear if users have other suggestions. the basic idea is to create several Table Queries and then paginate the Table data into several Steps that are then included in a Step Group to be printed.
I can see how your suggestion would help is the list was static, but unfortunately it will be dynamic. I have it coded to create a new entry when a procedure has a revision. When the revision is submitted, it will inactivate the old revision and activate the new one. I can then sort the list for active procedures for review as well as print out for an auditor. I can also view the entire revision history of a procedure in another query.
I could see carrying over the indexing number and make it tied to a procedure, but if a procedure gets obsoleted or a new one introduced, the indexing would be off.
The complication would get compounded when trying to print the current training matrix for an employee as the printable list would be generated off a query of the individual employee.
