Hello,
For Context:
I have created a database for my company to better maintain data that production workers were entering into an Excel file online. Instead of going through the hassle of entering the data into Excel in the browser I compiled the existing data from Excel into a coinciding table (MainData_tbl) in Access and created a Front End Form (Inspection_frm) that is located on all of the production computers.
To compliment the form I've also created multiple tables to give row sources to the combo boxes.
Issue:
To get to the point we are going to be using this database for a lot of analysis and when we do analyze the data we only want to see numbers, no names. The data I compiled used names for employees however I configured the form to show names for the employees combo box but write employee numbers to the 'MainData_tbl'. The row source for the employee combo box in the 'Inspections_frm' is from a table I created with just the employees names and their employee ids, the employee ids being the primary key (EmployeeDirectory_tbl).
So the data for employees in 'MainData_tbl' shows names for what I compiled from the Excel, and numbers for what has been input since I launched the Form for the employees to use. The latter is what is desired but as I compiled from Excel the older data is not in the desired format.
I need some sort of direction on how to change the employee names, from the compiled Excel data, to their respective employee numbers.