Display full concatenate filds

[Kim YooNa]

Hi 4 all!


I've got a database. There are 2 tables: Students and Ratings, 1 query and 1 form


In the students table I've got 2 fields: the First_name and the Last_name

In the Ratings table, in the field First_and_last_name I want to display the information from the query, but both fields and not the Firtst_name only.

My problem is the field First_and_last_name doesn't display in the table Ratings datasheet view both names


I will upload the database, but I did not have time to translate all the fields.
Students.accdb
Tks in advance for help!

P.S. I've tried to resize the images but I failed.

[pbaldy]

I personally wouldn't use a lookup field:



but to get both names you'd have to concatenate:

SELECT First_name & " " & Last_name FROM...

[Kim YooNa]

Hi Paul!
Tks for your advice... it worked!

[pbaldy]

Happy to help and welcome to the site by the way!