In the past I have generated a "Reference Number" for new forms submitted by setting the default value for the Reference Number-(integer Data type) to "max(@Reference_Number) +1". I now have a request to have the Reference Number begin with
"REQACH" followed by the number that is generated as above.
I assume that the data type needs to be set to string but that seems to disqualify the logic that I use above for generating the next "number". I've tried to generate this value using several different iterations of the Concat function with no
Any assistance you ca offer to help me meet this requirement will be greatly appreciated.
View Complete Post