dblookup, take highest number in view +1
Posted on 2008-06-20
I have a hidden view called $nn12
I have a field called NextNumber.
On my form I have an action hotspot/button to that I want to set the value of NextNumber to the highest value in coloum 1 of the $nn12 view, but increase the value by an increment of 1.
Also please note this value a numberical value but it has been stored in a text field.
Formula language is easier for me to understand but willing to accept LS so long as it is commented so I can see whats what.