Somehow one of my employees entered a Job Number in with 18 characters. Now when I try to make any changes in that job, it comes up with “Entry exceeds fields maximum length” and highlights the Job Number.
I already adjusted the size in the data dictionary, but I think it is with the Vantage program itself, not the database. When I look at the customization of Job Entry, the txtKeyField has a Data Format set to x(14). It is grayed out so I cannot adjust it. I’m not sure if this is the culprit or not.
Does anyone know how to fix this issue?
P.S. I tried connecting to ODBC and modifying the data through MSAccess. Too many indexes.