New Items - Non-Numeric Value

L Aksoy

August 14, 2021 06:57

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?

0

Comments

1 comment

Lothar Hasenkämper
August 16, 2021 05:31

Hi

you can try to convert/cast it to int, in yout query

regards Lothar

0

Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post