I have two tables. A CUSTOMER table, and an APPLICATION table. I am trying to create an application that can be completed online. First a user will create a customer, then proceed to a different form to enter the application data. Each customer stands alone in the customer table. But the applications allows a user to select up to two customers for the application.

I would like to create an unbound unenabled field to display the name of the customer based upon the ID number selected. I have done this before on other programs through the SQL statement but I have not been successful with this one.

Does anyone have any suggestions??

Thanks for everything! http://www.access-programmers.co.uk/ubb/smile.gif

If you want this field to be unbound, try the DLookup funtion. The Access help file for this function should get you there.

Eric