Subject Re: unconventional index From Mervyn Bick <invalid@invalid.invalid> Date Tue, 12 Dec 2023 12:46:32 +0200 Newsgroups dbase.getting-started On 2023/12/12 00:03, Charlie wrote: > I don't know if this is possible but is it possible to alter an alphabetical order using an index of some kind?? > > Example being instead of having a table indexed alphabetically, like ABCDEF.  Somehow alter the order like ACBDFE? > > Thanks for any comments. > > The only way you're going to be able to do this with a .dbf table is to add a field to your table as Tim has suggested. If you can't develop an algorithm that will create the sort order you need I'm afraid you will need to populate the sort field by hand which could be a real PITA. If you give us an idea of just how you need to rearrange the list someone may come up with some code. Mervyn.