I have a table of Division_District that looks like this:
As seen here, the District column is a mix of numbers and text.
I have another table PermitList with a column for District and Division with the Suggested Values set as follows:
It appears that only recently my application is preventing me from saving a new record in PermitList giving me the error:
Cannot convert ‘Value of District Column’ to Enum
Several days ago it seems that this was working just fine and now I don’t know what the problem is? Do I specifically need to convert the ‘Suggested Values’ to a list of text values when the dependent District suggested values may only be numbers? Any solution would be helpful. Thank you