Rookie Question: Display Lookup Value When Code Changes
I have two fields, a Position Code and a Position Title field.
The Position Code field is set up as a Drop Down Selection Field using a lookup table of Positions Codes and Position Titles.
The Position Title field is set up as a non-editable Display Field.
I need to have to the correct Position Title display whenever a user either enters or changes the Position Code field, either by typing in a new value or by selecting a value from the Drop Down list.
I think I can use the OnObjectModify script trigger but I am not sure how to set this all up.
Any help or examples would be much appreciated.