[Question] How to merge 2 attributes in a drop down

[Chris]

Hi all
I am very new to nuBuilder and to this community. So my learning curve is still steep and I hope you forgive my possible stupid and very noob question.

I have 2 tables, one is "contacts" which is referenced to a table "cities" containing the attributes "ZIP code" and "city".
In my form I would like to be able to change the person's address and also the ZIP code and the city.
So I would like to have a dropdown displaying the Zip Code and the city at once and change the record (the foreign key of the contact) upon selection.

I haven't figured out yet how to do that. Of course I can display and edit the foreign key to the "cities" table of that contact in my customer form. That works fine.
But that's obviously not the goal.
If someone could give me a hand, that would enable me to understand the concept in nuBuilder much better.
Thank you very much.
Chris

[kev1n]

Hi Chris and welcome

A Lookup Object might be what you are looking for.

User Guide, page 55

[Chris]

Thanks.
I actually looked for CONCAT(arg1, arg2) to display two values in a lookup