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

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?

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

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.

That will work. Thanks