faaslave Posted December 30, 2011 Posted December 30, 2011 Hello all, I have a field and I want an auto enter calc that does the following. Look at existing values for all records, find the highest value, and +1 That's it, but I can't seem to get the calc right. Thanks
comment Posted December 30, 2011 Posted December 30, 2011 I don't think you want to do that, because it's not reliable (two users could be doing the same thing at the same time). What are you trying to accomplish here that auto-entering a serial number wouldn't?
faaslave Posted December 31, 2011 Author Posted December 31, 2011 If I use a serial there is one problem. I am assigning member ID's for new members. So if we are on 9235 and I create a new record by accident then delete it, the next new member will get 9237. So numbers start getting skipped. That was the only thing I was trying to avoid
comment Posted December 31, 2011 Posted December 31, 2011 Why is that a problem? There are enough numbers for everyone... You could also set the serial to generate on commit - so that a record can be reverted without creating a gap.
Recommended Posts
This topic is 4964 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