Hi experts,
I would like to create a mandatory field on the table "Shipping Agent". It is an integer.
If I write my validation code in the OnInsert trigger on the table extension, it is too soon. When the user leaves the first field, it is validating the field that the user hasn't come to yet. That doesn't work.
If I write my validation code in the OnModify trigger on the table extension, it is not executed if the user simply enter a value in the first field and then leave the record. That doesn't work either.
I have another table, that I have created in my app. That table has a page, where I have set "DelayedInsert = true". That works, but I cannot set this in a page extension, but only directly on the page.
How do I make a simple and secure mandatory field, so that it is impossible for the user to create a record with zero in my integer field?