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?



1 comment

Please sign in to leave a comment.

Didn't find what you were looking for?

New post