Record Numbering

[polanskiman]

joebordes Wrote:

polanskiman Wrote:The only way at present to do this in a clean way so that the records ID are properly ordered is simply not to put any prefix, or add x amount of 0s in the Start Sequence field prior the initial number.

The only way to do it is "adding x amount of 0s", I don't think that ommiting the prefix will help. In any case, I don't see much of an issue about sorting with a given amount of 0x in place, in fact, I personally like it as it gives all records a consistent size.

I understand that you would like to have the records ordered by prefix and then numerically. right?

No I want records to be ordered by their number. I beleive the prefix is only there for readability reasons but doesn't really serve any other purpose. It doesn't make sence to order by prefix since the prefix is the same for all records within a module

In fact I have noticed that adding x 0s in the Start Sequence field doesn't work if you do an import after. If you add a record manually the squencing works while if you do an import it doesn't and all 0s are suppressed.

Back to square one.