i am having problems with this and hope someone can help.
Take the following example
I have single table say test, that has 2 fields an 'id' field which is the primary key and a 'name' field.
On my screen i want the following. A combobox that has the id's and a text box which display's the corrosponding name.
I can populate my combobox with the data from id field and display a name in my text box, i can browse the ok through << < > >> buttons on my form, but want to be able to also browse by selecting an id from the combobox and making the textbox corrospond to this.
When I do this im getting primary key must be unique constraint violations etc. looks to me like the dataset gets updated when the combobox is changed, rather than just leaving the dataset alone and updating databindingcontext position.
Im sure this must be a fairly common problem, (sorry dont have code on me at the moment).
But can someone please come back and let me know the general way of doing this, thanks!
Take the following example
I have single table say test, that has 2 fields an 'id' field which is the primary key and a 'name' field.
On my screen i want the following. A combobox that has the id's and a text box which display's the corrosponding name.
I can populate my combobox with the data from id field and display a name in my text box, i can browse the ok through << < > >> buttons on my form, but want to be able to also browse by selecting an id from the combobox and making the textbox corrospond to this.
When I do this im getting primary key must be unique constraint violations etc. looks to me like the dataset gets updated when the combobox is changed, rather than just leaving the dataset alone and updating databindingcontext position.
Im sure this must be a fairly common problem, (sorry dont have code on me at the moment).
But can someone please come back and let me know the general way of doing this, thanks!
