Showing Primary Key as Company name

[nyma96]

how do I set up supplier name in the order table like the example in the
northwind database?

what I mean is set supplier ID so that it shows combo box with names instead of numbers.

 

[Ron_dK]

Change the bound column number to the name field of the supplier in the combobox properties.

 

[Pat Hartman]

Change the bound column number to the name field of the supplier in the combobox properties.

NO! The bound column is the column that is saved. That is supposed to be the SupplierID. To control what shows in the combo, modify the Column Widths property.
"0", "2"
Will HIDE the id column (assuming that is first as it normally is) and SHOW the SupplierName field.

Make sure the column count property is correct and make sure that all columns are accounted for in the ColumnWidths property.

 

[nyma96]

Thanks Pat!

That did the Trick...