I have a column in my list that is based on the records in another SharePoint list. When I try to edit a record in Datasheet View, I frequently get the following validation rule failure message:
The text entered for Client Impacted isn't an item from the list. Select an item from the list, or enter text that matches one of the listed items.
Even though the column appears to be blank to the naked eye, when you double click in the column, it selects what appears to be a space character and when you hit the delete key, it now passes the validation rule. So, my assumption is that the validation
rule is saying something like "Space character isn't in the list, so you can't save the record..." Here's what's odd. I do NOT get the same validation rule warning when I edit in standard view and I know for sure that the column has not been erroneously
filled with a space character. Anyone have any idea what might be going on here?
Thanks in advance for your help.
View Complete Post