[AccessD] ComboBox Rowsource With 2 Field PK

Hi Access-D,

I have a table which cannot be edited per client 
instruction. It is linked into the current database
as the customer table and has two text fields that
comprise the primary key (Division and CustomerNo)

A third field, CustomerName, is the one I would like
to show in my combobox on my form in order to
select a customer. I cannot, however, make one 
or the other the bound column as the customer name
just disappears.

I have tried Bound Column: 1,2 and 1;2.
Doesn't work.
Does anyone know what I must do?

Mike Mattys