1 of 1 people found this helpful
Very easy to replecate the error, and I can say only 'this is a bug'...
I use fms18.104.22.1685 on Win7, FMServer_Sample.fmp12 as admin account.
I found that valuelist like 1/2/3 (use only numbers) is working as expected, both used in number and text field.
Thanks for the confirmation. I'll post a bug report.
I found the reason that I was getting the error was a permission setting.
The user account was set to No Access for value lists. Once I allowed the user to see the value lists needed for the validation the error went away.
I tested as admin (Full Access), so here may be another reason.
I said 'number seems working', but it is wrong. Newly made custom value list is working, but 'Status' value list (using field value) cause error...
The value list may returning another values if FMPro or CWP-XML. Using FMServer_Sample was not good for test.