I would like to create a function "nextvalue" and assign the value returned to a field (Case_no). Based on the current year, this function will query a table(Scap_Case_Logs)to find the last number assigned in case_no and add 1. For example, the function would return 4 based on the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.