>>>>>>Not? I got record Id something like an emp_id.
>>>>>>Cetin
>>>>>
>>>>>I meant that date has nothing to do with relation.
>>>>
>>>>You want to relate two tables by ID and show child table in the descending date order.
>>>
>>>I don't want to use SET RELATION for that, and nobody should. If you want to do it then do it as you always do: get a recordset.
>>
>>Me neither, actually :) I don't think I use SET RELATION command in my code, only in the quick tries in the command window.
>>
>>But if we consider the theoretical question... :)
>
>Come on. Not in theory. I do use SET RELATION in my code and will continue to use until something better is invented (and VFP not having another version unlikely).
>Cetin
I don't have it in my code, AFAIK, but I do have it in the code by my colleague. That reminds me to start some test I forgot to do...
Thanks.
If it's not broken, fix it until it is.
My Blog