AnsweredAssumed Answered

How to best select a relating record without showing the record ID

Question asked by jonasmn on Jul 10, 2018
Latest reply on Jul 11, 2018 by MichaelManousos

I have a database with employees (EMPLOYEE), set up basically like this:

 

ID_Employee

Name_employee

 

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:

 

ID_Timecard

IDf_Employee

Time_start

Time_finnish

Time_total

Task

 

In

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?

 

 

Regards

Jonas

Sweden

Outcomes