I have an access DB acting as a front end to MySQL using ODBC Linked Tables. It's for a python based clocking in system generating the records. I have a Staff Maintenance form that allows HR to update staff information including assigning a Fob ID. The Fob ID is unique and when scanned on a fob reader is placed in a table called "scannedfob" in a field called "fob_number".
The form is called Staff Maintenance and edits information in the "users" table.
I would like to be able to scan a fob, have the linked table "scanned fob" refresh, copy the fob_number.scannedfob field into the users.rf_uid field for the current record I am looking at in the form and then delete the record out of the scannedfob table. I expect I will need a button to carry out these actions but not sure where to start really.
I should add, I am not a database specialist nor a programmer but an IT manager. I am learning quickly but not quick enough to get this finished! Any help greatly appreciated.
Thanks
Graham
The form is called Staff Maintenance and edits information in the "users" table.
I would like to be able to scan a fob, have the linked table "scanned fob" refresh, copy the fob_number.scannedfob field into the users.rf_uid field for the current record I am looking at in the form and then delete the record out of the scannedfob table. I expect I will need a button to carry out these actions but not sure where to start really.
I should add, I am not a database specialist nor a programmer but an IT manager. I am learning quickly but not quick enough to get this finished! Any help greatly appreciated.
Thanks
Graham