New Items - Non-Numeric Value
I am trying to use New Items to add an field to a form using a textedit and query that allows users to choose from OPRC (profit centers). But the PK for this table is a string (PrcCode) instead of an integer and selecting an item throws a Invalid Numeric Value error.
How can I work around this?
you can try to convert/cast it to int, in yout query
Please sign in to leave a comment.