I have a base with all our members and there details in.
In one field we have numbers, in the other field we have a field with a Formula that works out the membership number.
Our membership changes and sometimes people leave. When they leave we delete them from the Base.
When we delete the row they are in, the numbers all change again, and this changes all the existing member numbers.
Is it possible to delete a row but not change the other rows numbers.