Creating a Log to Track Input
I'm stuck...and can't find anything similar to my situation.
I created a self-service database where students can scan their IDs to retrieve their computer passwords. I'd like to track who scans and when (CurrentDateTime, student ID, first and last name from StudentLogins).
I have set-up two tables: one is the user interface (UI) and the other contains the student data (StudentLogins). Fairly straight-forward - a student would scan their ID and their password would pop up within the UI.