>>>>>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