AUTO-ENTERING VALUES BASED ON LAST RECORD
i have a table that tracks spot light movements and changes for theatrical productinons.
there are 8 "spots" across the layout and each new record goes down as time progresses in sequence
i am trying to create a script that can see what is entered in the last field and then make a decision to auto enter another piece of text depending on what the previous value is. i can send more information and images if this is pausible.