Can anyone help me Set Field By Name according to the last active record on a different table?
I have a field called CheckoutDate on the CheckOut layout. OnObjectValidate I want to launch a script trigger which changes/sets a different field, called patronID, to the last active record on the previous layout, CirculationDesk.
This is how I got my script started:
- Set Field By Name [Master::patronID]
- I'm stumped on what the calculation would be. The calculation would need to retrieve the last active record on the CirculationDesk layout so that it could be put in the target field (patronID).
The CirculationDesk and CheckOut layouts have a common field named Full_Name. (is that info needed?)