Solved: Re: Referencing two columns at a time

flan828 · 12-13-2021 07:27 AM

In my tables I have f_name representing the first name and l_name representing last name. l_name is currently the label.
I have two tables parent_table and student_table. Each table contains these f_name and l_name columns.

it could be that parent_table, for example, could contain two people named Mike. so when entering in a student and I click on the drop down that has a reference to the parent_table it lists parents however I only see the parent’s last name. Because the last name is the current label. As mentioned earlier, I could make the f_name the label however, I could have two parents with the same first name.

I would like to be able to, when clicking on the dropdown, be able to see the parent’s first and last name.

I have been looking all over to try to figure this out and have been having issues finding a suitable solution. Can anyone point me in the right direction?

Thanks,
Steve

Aurelien

Hi @flan828

Add a virtual column “fullName” in your table, with expression:
CONCATENATE([f_name] , " " , [l_name])
and set this one as label.

View solution in original post

Aurelien

Hi @flan828

Add a virtual column “fullName” in your table, with expression:
CONCATENATE([f_name] , " " , [l_name])
and set this one as label.

flan828

I tried that but I guess my syntax was a bit off!

SkrOYC

You should try this if you are using a Chromium-based browser (that’s not Edge btw)

flan828

thank you I will give it a shot.