Hi all!
I have an requirement to write validations on modifying an edit method field in the "All favorites" form under PMA --> Setup --> Timesheets.
This edit method validates the activity number given by the user and populates the data into the Activity number field of the data source of the form.
My requirement is to perform a validation on modifying the edit method field. The validation works for the activity number if we create a record with legal entity as current company. But I was not able to do validation if I select a different legal entity(Eg.USRT) for the record under the current company(USMF).
Things that I tried so far and didn't work:
1) Taking COC for validate field of the table and called the validate field under on modifying event of the form string control. On this occasion the standard error for table relation strikes as the system checks the value of selected activity number of a different legal entity with the Activities table of the current legal entity.
2) On validating and On validated write events of the string control (As the string control does not have the selected string value when being hit)
Appreciate any inputs on it.