>>>>>>>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
I meant that date has nothing to do with relation.
Edward Pikman
Independent Consultant