>>>>>>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 :).

Not? I got record Id something like an emp_id.
Cetin