I made a custom list, CusineType, with several keys (chinese, japanese, italian, etc). I then created a custom field called Cusine_Type_c, linked to the dropdown. I added this field to my account edit and account detail views . It all looks fine, but when you click "Save" I get the following:
Cannot insert the value NULL into column 'RELEVANCE_C', table 'SplendidCRM.dbo.ACCOUNTS_CSTM'; column does not allow nulls. UPDATE fails. The statement has been terminated.
Can someone please tell me what I'm doing wrong? Is there a doc somewhere explaining how to correctly create custom dropdowns? Any help would be appreciated, thanks!
Clear the Required Field flag. It will only work if the table is empty. When the field is required, we create it as NOT NULL.
Thanks for the help!
Ok, I recreated the field and removed the "required field" flag. I can now go in, select an option, and click save without an error, but the change does not persist.
It goes back to being "blank".
I have these checked in the DetailView Field.
Data Required:UI Required:
Any ideas?
I tried unchecking the boxes, no difference.
What is the size of the custom field you created? Is it possible that the length of the list exceeds the length of the field?
Another thing you can try is to change the EditView to be a textbox. This should confirm that data is being saved to the custom field.
