we are using access for our customer enquiry database. In our 'customer column we would like to set up a combe or list box which enables us to choose a customer from the list that we have been building up. However despite making adjustments in the design view look up section we find that the only listings returned in the table are the sequential numbers from the primary key.
Please can someone advise. What are we overlooking?
regards,

You can choose both fields (cusID, cusName), then set the properties of column count to 2, column width to 0";1"

thanks for advice.

However I have set as you suggested for 'Customer' column and it is now listing details of a different column called 'enquiry numbers' (Example: LY1943-...LY2210). The table has 732 entries, approx: 50 customers

regards

Did you check your control source of that combo box? It shouldn't be EnquiryNUm. Check your query,too. Do you have EnquiryNum in there? If you do, cut it out.
Hope it works.

still struggling!!

The control source gives 3 options. We have it set to 'job log' the name of the table we are working in. The other two options refer to a query table & a report table.

You need to create a query. Click on the right side of the pull down arrow on the row source property, it will bring you to the design view of a query. Add table Customer in by right click and select Show Table. Select customerID and customerName.

success!!

thanks for your help