COMBOBOX IN DATASHEET VIEW

Can u please explain - Why is in Northwind database, in ORDER DETAILS table
productId is number filed, but it displays the product name in the datashet
view. I know this is the combo box assigned to the field with bound column
set to 1 and counm count 2,
I am trying the same thing wth JUDGEship table. It displays the combobox
with judgenames (the field is JudgeCode -number ) but when i select one from
the list it says data type mismatch. where i am making mistake to select name
but store the JudgeID?
i
hope u understood what i need exactly?

Look at the Column Widths property.

The first column i zero-width, so the combo displays the 2nd one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"smita" wrote in message
...
Can u please explain - Why is in Northwind database, in ORDER DETAILS
table
productId is number filed, but it displays the product name in the
datashet
view. I know this is the combo box assigned to the field with bound column
set to 1 and counm count 2,
I am trying the same thing wth JUDGEship table. It displays the combobox
with judgenames (the field is JudgeCode -number ) but when i select one
from
the list it says data type mismatch. where i am making mistake to select
name
but store the JudgeID?
i
hope u understood what i need exactly?