Numbering in the Database
This might be an easy fix, I don't know. I've inherited a filemaker database set up for several hundred numbered samples. Each time a new sample is entered into the database, it is assigned a unique number. However, over time, there have gotten to be problems with this system, because each time an entry is deleted the number that was assigned to it isn't recycled. So, for example, if database entry #7 for sample #7 is deleted and then reentered into the database, the entry number is now #8 for tube #7. These deletions and frame shifts have built up over time, leading to an incredible confusing and innacurate correlation between tube number and entry number.
Is there an easy fix for this, or is it going to require renumbering the whole database by hand?