I have a datagrid where users can put in their data directly.
I also have a "save" button so that the user can save his or her changes.
But i have a problem with my primary key!
I made a column for the primary key.
I dont want the user to be able to change the primary key cells. So i want the application to fill the primary key cells automaticly.
But when i made the key to autoincrement = true, then i get an error becouse most of the time the number that the application give to the cell (by means of the autoincrement) is already used in another primary key cell!
I could however use another column as primary key. But when i do this, the user won't be able to change the cells in that column becouse the application won't let you change a primary key if it has already a number in it.
You see my problem? I really have no idea what the sollution may be.
I would be VERY greatfull to the one who can help me :-)