>>>Actually, I think that is a good question.
>>>I'm trying to create a relationship between two tables through record ids, but I want the child table to be in reverse date order.
>>>
>>>Do you think I going about it correctly?
>>
>>In your current task description you're correct. If, for example, you would want a key based on a numeric field (not integer) in ascending order
>>and a date in descending order, you would use something like:
>>
>>
padl(myNumField,10,'0') + padl({^9999-01-01} - DateField),10,'0')
>>
>>The idea was discussed long time ago here as well.
>>
>>But it would not work for NULL and empty dates, so the index expression should be a little bit more complex...
>
>No need for tricky expressions:) bintoc()+dtos(), descending.
>Cetin
I've changed the original problem definition, didn't you see the description of a new problem I was trying to solve?
Thanks.
If it's not broken, fix it until it is.
My Blog