So right now I have a few tabs linked where I will add a patient number, then add a certain number of trials. Each trial generates its own ID on a new tab and right now it is entered as Indexed, Auto-enter serial. The issue is, when I make a mistake like add a unwanted record or want to delete an old record, the Auto-serial number does not reset. Let me give you an example:
Patient 5 Trial ID
-Trial A generated on other tab - 1
-Trial B -----------------> - 2
-Trial D - 4
Now let's say Trial C was a wash or mistake or something so I took it out. AFTER I TOOK OUT trial C (ID 3), I entered Trial D. I want Trial D to auto generate its ID as 3, not 4. As of now, I have to manually go back into the field and enter the serial number starting position.
Is there any way to make the auto-entered serial to link up with the records that are present and/or deleted.