Hi,


I am trying to run a query from an orders database with the suppliers names in a combo box.

When the query runs it does not retrieve the supplier's name but displays a number. I'm not even sure where this number is retrieved from as it is not the SupplierID number in the underlying table.

I'm sure that the problem can be resolved easily but I don't have the knowledge skills to resolve it.

any help would be greatly appreciated.
Thanks