I have mysql setup on the backend and it's hosting my timeclock database which has two tables I need to work with, but I have no idea how to make access do what I want. In one table I have the employee information including RFID number. In the other table, I have the punch in information that get populated by a web frontend. I want to add the ability to punch in via RFID using an MS Access front end. I don't know how to get the database to take the rfid number, associate it with the employee name (both in one table) and put that information into the punch table with the current time and date.
In other words I want a blank form with the focus on a singular input box that when I scan the RFID card, it translates the number to a name and place the name in the appropriate table with the current time and date. In a nut shell, that's it.
If anyone could please help me, I would very much appreciate it. I never ask for help, but I've spent all day trying to think about this and my brain just doesn't understand databases. Thanks!