Concatenate two fields and then make a lookup box

How do I combine two fields and then make them a lookup box? I know how to
make a lookup box in a table (using the lookup wizard) and know how to
concatenate two fields in a Query, but how do I do both? Would this be using
an Expression?

Shannon,

Field concatenation for any purpose other than just display/print is
very rarely required; most likely there's a better way to achieve what
you want, if you care to explain what that is.
Moreover, most people answering posts here will agree that whoever put
in the lookup box functionality in tables should have been fired from MS
before the end of the beta testing, but certainly after he/she had
removed it from the final product... why do you need it? Tables are not
intended for entering / editing data, that should be handled in forms.
Again, care to explain?

Nikos

Shannon wrote:
How do I combine two fields and then make them a lookup box? I know how to
make a lookup box in a table (using the lookup wizard) and know how to
concatenate two fields in a Query, but how do I do both? Would this be using
an Expression?

Nikos, thank you for your response. I decided to delete the two fields and
made it into one. This seemed to work, then I was able to make a look up and
put it into my form. Shannon

"Nikos Yannacopoulos" wrote:

Shannon,

Field concatenation for any purpose other than just display/print is
very rarely required; most likely there's a better way to achieve what
you want, if you care to explain what that is.
Moreover, most people answering posts here will agree that whoever put
in the lookup box functionality in tables should have been fired from MS
before the end of the beta testing, but certainly after he/she had
removed it from the final product... why do you need it? Tables are not
intended for entering / editing data, that should be handled in forms.
Again, care to explain?

Nikos

Shannon wrote:
How do I combine two fields and then make them a lookup box? I know how to
make a lookup box in a table (using the lookup wizard) and know how to
concatenate two fields in a Query, but how do I do both? Would this be using
an Expression?