Order calculation script trigger by date (or last entry)?
I have a field called "location" for my inventory, and also aocation history. The location field runs a script trigger on save that first of all goes to the field "location history" and then runs "(ARTWORK::LOCATION) & " - " & Get ( CurrentDate ) & ¶"
First of all, is this the cleanest way to do this? In order keep track of the history of movements in a stock item?
Secondly, how do you order it so the latest entry in the history goes to the top of the field?