Solved: Search homonymous name and insert name e surname t... - Page 2

Cannone_Cannone · 03-22-2024 02:43 PM

Hi everyone
I have a small problem to solve, I have 2 tables, one "staff table" with 3 columns Name, Surname, ID and the other table "Insertion Form".
I should insert the name and surname of my staff in the "Loading Form" table which I look for in the "Staff" table. The problem is that there are names and surnames of the same name. I tried to create a virtual column in the "Staff" table with the concatenate formula. but I can't do what I want. I would like how can I solve it? thank you all

Joseph_Seddik

Sorry for late reply. I believe you could set a virtual column concatenating the Name and Surname fields, like this: [Name] & " " & [Surname]

You'll then just have to set this virtual column as Label and make it searchable.

View solution in original post

Search homonymous name and insert name e surname to different field