>>>>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?
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville
No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)