Search results

Thank you for the comprehensive answer, I will try these techinques.

Thanks. Do you mean that the only purpose of multiple fields in the lookup selection query is for the selection through the lookup field, but the fields cannot be displayed this way in the form or table or table row after the selection?

Thankyou. I do get a return of all three fields witha query, and also in the table selection lookup I can see the proper two fields, building and apartment.

I have two simple Access 2007 tables and have successfully created a two field lookup using the wizard. I am able to see the two columns in the table or form, and can select and save records that I wish to bind. However, in my table or form display I can only see the second field although I...