Scrolling thru records

[Fluffy]

Hello,

I have chosen my ID field as a text field. Some examples of existing ones are PC-0001 and PC-0018...

When I create a new record, I can name it PC-0002, although PC-0018 already exists.

I have made these scrollbuttons with the wizard, but when I scroll thru them, I get my records chronologically in order of creation. I want them sorted by number.

How can I do this?

Thanks,
Oswald

 

[maxmangion]

put your focus on the field you want to sort with and on top in toolbar you have 2 icons A-Z (ascending) and the other Z-A (descending), click which one you need (you should get the sort order) and then click on the save button.

The next time you open the form it should be sorted in the way you want!

 

[Fluffy]

Thank you,

but that just sorts the info that is already stored. Every time I enter a new one, it has to be sorted like that again.

Is there a way this can be done automatically?

 

[maxmangion]

when you close the form, the next time you open it everything will be sorted correctly.