I am needing the max value of a field to display and add one to that number. This will be working as a transport number in this case and needs to be calculating and set. Also I am needing to use my own starting number.
Right now it doesnt seem to want to show anything.
max(@TRANSPORT_NUM)+1 is what I am trying to work with.
Any ...