Ocean West Posted May 15, 2016 Posted May 15, 2016 Trying to come up with a way to auto enter a serial number that resets each year. user enters in the a date field "production date" the year of that should prefix the serial number 161001 on average < 4000 records per year created Preferred not to be scripted and want it to auto increment on if record is duplicated. And not change if someone changes the production day (as long as its in the current year)
Recommended Posts
This topic is 3207 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now