What is the best method to perform validation on a users field entry in regards to current values in a table? Currently I have created a new tab in Sales Order Entry with a field in which users enter the “original part # purchased”. I want to have a validation in place that checks if the part # they are entering exists in the database. Is the best way to go about this by creating a BAQ and link it to the field in “Customization Tools Dialog>>Script Editor”?
If you want to capture the validation before the data is submitted to the table, an in-transaction data directive on the table would work great.
2 Likes