I have a transactions table. When I enter new stock I want to automatically enter the box number where it is located as the value from the previous record so I don't have to repeatedly enter the box number. Checking the value from last visited record box makes this work well for me.
But when I am making sales I use the transactions tables too. In this case I don't want to auto enter the box number. I use a different layout for sales.
So maybe I could use a script trigger related to the layout. I tried a trigger which sets the field to "" when the record loads. But this deleted location numbers when I looked at previously entered records. Is there a way of conditionally setting the trigger to fire only when the record is new.
Looking forward to hearing back.