validate a record
On an order entry layout I have a field called Wood Finish which is in a portal based upon the lines table. I need to be able to lookup a field called FinLeg in Frames table. If FinLeg >0 then I need a dialog box to remind the operator to select a wood finish if they have left it blank. This needs to be validated when the operator moves to another row in the portal. Can you help me with this?
You may need to do a bit of trial an error with different script triggers that perform a script to do this to see which works best. My best guess is that you can set up the OnObjectValidate trigger on the portal to perform this check on the current portal row at the time the user exits the portal row.