using an expression to add text file to a single field and then use that field as a drop down menu

[King Kaos]

Is it to build an expression in a query that puts several, text field
together. For example I have client information and I have their home
address, school address, court house address, doctor's address etc. What I
want to do is create an expression in a query, that "puts" these fields
together and then on another table/form/query - when I bring up a client's
name, I want drop down field that would bring up these various addresses -
is that possible ? Thanks



Keith