Well we would then look at the corresponding customer information to make sure we had the correct info. Sorry this really isnt a real life situation as we shouldnt have two customers with the same name.
So how would you design? Very odd this is like DB101. If you had a student table with five students named john smith you identify the difference by there id.
So are you saying that if I want to query a table based on the selection I have to have customer name referenced in other tables??? No that cant be right I look at referential db's most of the day they are linked on ids not names??
Someone out there must have run into this along the way.
Well looking at the documentation[^] it is clear that the items in the combobox can be objects, so you just need a class of object that contains the name and the id of the customer. The object's ToString() method should return the name which (I guess) will appear in the combo box.
One of these days I'm going to think of a really clever signature.