HELP!!!

[idgely]

I need to know how to generate a client number based on the record number. Easy enough. Problem is that they want some special functionality that is beyond me:

Let's say we have records 1,2,3,4. With client numbers 101,102,103,104 respectively.

We delete record 2(thus deleting client number 102), and rather than assigning record 105 to the next one that is created, they want it to assign client number 102 since that number is no longer in use.

How would I do this?

[dual_mon]

Okay, first of all... WHY!!!

Second of all... You could do this in a number of ways. One way that comes to mind is to sort by the client number and then loop through the records starting with the lowest number, testing each one to see if it equals the previous client number + 1. When you find a gap or reach the end, use that number.

Third of all... Please use a subject line that is informative about what the thread is about. Subject: HELP!!! is very bad netiquette.