I have a database with employees (EMPLOYEE), set up basically like this:
In a second database (TIMECARD) I want to enter the time that the employee has worked for a specific task, thus I want to select the employee from the related EMPLOYEE database. This is basically the TIMECARD database:
In the layout where I enter the information for the TIMECARD I want to select an employee from the EMPLOYEE database, but without having the ID of the employee displayed as well. As for now, the only way I have figured out how to select an employee, is to have two fields, ID_Name and Name_employee. I then select the proper ID_Employee in the Meny of the field ID_Name, and the ID is shown in that field and the name of the employee shows upp in the second field Name_Employee.
But I would like to get rid of the field ID_Name. Can this be done?