Try using the debugger. It will help you pinpoint the problem.
Debugger doesn't help. There is no any code neither at OnRename trigger nor Code - OnValidate. Also, there is no TableRelation on this field. PrimaryKey contains of one field (Code) only.
The code field is primary key field and in other table, Fields are connected with this field using Table Relation.
The problem might be that when you try to rename field "Code" shown in screenshot, it also goes to update other field value whose are connected with "Code" field in Table relation Property. You should check for all fields and their data type which are connected with "Code" field and their data type.
I think data type of any one field does not match with the data type of "Code" field .
If suggestion has solved your problem then please do not forget to mark it as solved.
The code field is primary key field and in other table, Fields are connected with this field using Table Relation.
The problem might be that when you try to rename field "Code" shown in screenshot, it also goes to update other field value whose are connected with "Code" field in Table relation Property. You should check for all fields and their data type which are connected with "Code" field and their data type.
I think data type of any one field does not match with the data type of "Code" field .
If suggestion has solved your problem then please do not forget to mark it as solved.
Hi dipakpatel2505,
You are absolutely right! I searched for table relations throughout the whole database and found boolean field in another table with relation to this Code field. Thanks a lot for your help!
I am getting this same error on trying to rename a record in a new custom table with the primary key a Code 10 field. There are 4 tables with fields relating to this table but all are defined correctly as Code 10. How did you find a field of type Boolean with a table relation to this table? Or what else could be causing this error?
I am getting this same error on trying to rename a record in a new custom table with the primary key a Code 10 field. There are 4 tables with fields relating to this table but all are defined correctly as Code 10. How did you find a field of type Boolean with a table relation to this table? Or what else could be causing this error?
I had the same issue this week while renaming customer record.
Then i found this discussion of which @dipakpatel2505's insight came in handy and @madalyn's idea of exporting objects to txt was very efficient.
So I filtered my objects to those modified, exported it to text and searched for customer table, then i saw the boolean field relating to customer table
Answers
http://www.BiloBeauty.com
http://www.autismspeaks.org
http://msdn.microsoft.com/en-us/library/dd354968.aspx
http://www.BiloBeauty.com
http://www.autismspeaks.org
The code field is primary key field and in other table, Fields are connected with this field using Table Relation.
The problem might be that when you try to rename field "Code" shown in screenshot, it also goes to update other field value whose are connected with "Code" field in Table relation Property. You should check for all fields and their data type which are connected with "Code" field and their data type.
I think data type of any one field does not match with the data type of "Code" field .
If suggestion has solved your problem then please do not forget to mark it as solved.
You are absolutely right! I searched for table relations throughout the whole database and found boolean field in another table with relation to this Code field. Thanks a lot for your help!
Then i found this discussion of which @dipakpatel2505's insight came in handy and @madalyn's idea of exporting objects to txt was very efficient.
So I filtered my objects to those modified, exported it to text and searched for customer table, then i saw the boolean field relating to customer table