In Access 97 I had a simple popup form bound to a table. It contains a Ticket Number and an Employee ID number. You enter the Ticket No. and select the employee.
I have a command button that allows you to print the Ticket report that is assigned to the Employee ID that was just entered. In...