>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

Koen,

Try this instead

iif(empty(field2),'1' + Field1, '2' + Field2) + field2 + field3 // Looks like you don't care about dates here