Hi I have a problem I have a form where use...

(Sakis Koukouvis) #1

Hi

I have a problem

I have a form where users have to choose names from a fileld (Ref) from

a table CUSTOMERS

Many customers have similar names e.g. John Smith

They don’t know who is this John Smith among others with the same name

In the same table I have a field “STREET”.

If the users could see in the same dropdown menu the NAME and the STREET they could easily choose the right Customer

Is this possible to have two columns from the same table in the dropdown menu?

Thank you

Sakis

(Aleksi Alkio) #2

Create a virtual column as a label and then it will show you both values. You just need to combine them in that virtual column.