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?