It's much better way, because candidate tag will ensure data integrity, and 'active' field will simplify and speed querying. Just imagine, that for some reason 'active' task is not the most recent one. It might not happen but it should convince you :).
>I had thought about it, but I feel this is an unnecessary data field. Perhaps I'll be persuaded to change my mind <g>, but not yet.
>
>>Your task will be much better accomplished if you keep 'Activetask' field (logical) in the child table, providing that you have only one record in child group with Activetask=.T. (you may have a candidate tag on parentid for activeflag=.t.).
Edward Pikman
Independent Consultant