>>>>>Hello all
>>>>>
>>>>>What is the best way to use an integer field plus a date field to create an index?
>>>>>
>>>>>TIA
>>>>Depends.
>>>>What you need might be bintoc(fi)+dtos(fd), dtos(fd)+bintoc(fi), padl(fi,10,'0')+dtos(fd) and vice versa.
>>>>Cetin
>>>
>>>details, details. you're killing me with details. :)
>>>
>>>thanks.
>>
>>Well you're lucky I didn't ask why would you need such a compound key:)
>>Cetin
>
>
>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?

Sure not. You don't need in this relationship :).