>>Hi,
>>
>>I need to index a table, which I now almost believe I am looking for the impossible, but knowing nothing is impossible. Here is my problem:
>>

>>create cursor toindex (field1 c(20), field2 c(20), FIELD3 c(20))
>>insert into toindex (field1,field2,FIELD3) values ('abcd', ' ', 'number1')
>>insert into toindex(field1,field2,FIELD3) values('efgh','abcd','31/03/2008')
>>insert into toindex(field1,field2,FIELD3) values('ghij','bcde','11/05/2008')
>>insert into toindex(field1,field2,FIELD3) values('hiij','bcde','18/05/2008')
>>insert into toindex (field1,field2,FIELD3) values ('bdce',' ','number2')
>>insert into toindex(field1,field2,FIELD3) values('fghi','abcd','01/03/2008')
>>

>>what I need is a sequence :
>>

>>abcd	" "		number1
>>efgh	abcd	31/03/2008
>>fghi	abcd	01/03/2008
>>bcde	" 	"	number2
>>hiij		bcde	18/05/2008
>>ghij		bcde	11/05/2008
>>

>
>>field number 3 contents either characters in which case field number2 = empty or a date(dd/mm/yyyy)
>>field number 2 has a crossrefrence to field1 (just like in a simple treeview)
>>
>>How to compose my index?
>>
>>Any assistance is highly appreciated!
>>
>>Thanks,
>>
>>Koen
>
>It's not clear even how to create such order in a query. Can you get your data with a query and ORDER BY ?

Something like

INDEX ON IIF(empty(Field2), Field1,Field2) + Field1 + IIF(empty(field2), Field3, DTOS(Field3)) TAG myComplexTag

not tested, of course, just from the top of my head.