Hey,
I have a view to a database that I have created for Client Maintenance. It has
a number of fields, but the important ones are Medical Condition, Bill To, and
Country.
I have a couple of external tables: One for Countries that store each Country
as a ID (char(2)), and Name (varchar(50)) pair; One for Medical Conditions,
using ID (int) and Name (varchar(50)). Also, the BillTo field refers back to
the same table that is being displayed, although using another BindingSource.
What I have found is that, when I link up the datasource, display member,
value member, and selected value using the appropriate values, the comboboxes
have the correct values, and can be set to these perfectly fine. However, both
the Medical Condition and the BillTo comboboxes, once the value is changed,
refuse to release the focus. The intriguing thing is that the Country combobox
does work perfectly fine, and this value can be changed and then lose focus,
and can even be saved, without issue. Hence I can't see why the exact same
process is not working for BillTo and Medical Condition
The only difference I can see is that the Value field of the datasource is an
integer for the two that are failing but char values for the Country, but I
would think this would only cause a problem on saving.
Has anyone come across this issue and able to give advice as to the problem?
Regards,
Wingot