> 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 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? 
>