After change the Key of the table, it displays the error

klinspatrick

Hi, i have changed the key in the table of the "New Vendor for supplier" and i also delete the testing records in the table, and it shows below message when i input the record in the field of No.

Thank you!

"You can not rename a record because the old value of the field below is",

Field: No.
Table: New Vendor for supplier

David_Cox

Delete the record then set the Key fields property to Not Blank, what is happening it is inserting a record with a blank Key, then trying to modify it.

You could also set the form to delayed Insert, if a blank field is allowed, this will then not update until you move the record pointer.

klinspatrick

thanks a lot, david, the problem is solved.