Join name fields

[RustyRick]

Maybe this is a dumb question. I have a DB with 2 tables. An employee table and a work log table. Equally the same to populate them with 2 forms.

The work log table is connected through the employee's ID number. But for confirmation I need to have the employees full name pop up on the work log form when I input or choose the employee's number.

So do I need to, or is it best to put the "Full Name" field in the Employee table?

 

[Beetle]

I need to have the employees full name pop up on the work log form when I input or choose the employee's number.

You do this with a combo box. You can display the name in the combo box, or , if you have a need to display some other value in the combo box, you can still return the FirstName and LastName fields, or a concatenated FullName field, in the row source of the combo box and then display that in a separate unbound text box by referencing the appropriate column of the combo box. So the Control Source of the unbound text box would look like;

=[YourComboBox].Column(n)

where n is the index value of the relevant column in the combo box Row Source query. The index is zero based, so the first column is Column(0), the second is Column(1), etc.

is it best to put the "Full Name" field in the Employee table?

You should have FirstName and LastName fields in the table, not FullName. If you need FullName you would return this in a query or form/report control by concatenating the First and Last name.

 

[RustyRick]

Aw thanks - that's precisely what I wanted to know. I need a full name field in the "Work Log" table.

So I put a calculation to concatenate the 2 fields in the Employee table and include that in a query.