>>Using vfp5...
>>
>>When I save my parent I need to set a flag in the parent table indicating
>>whether or not the parent has children. This really speeds up another
>>part of my app. I was going to do a locate during the save and see if
>>it finds any children. Is there some slick way to do this?
>
>Check out the Lookup() function. You could create a stored procedure and set the default of your flag to the results of the stored procedure.

I'm sorry. Indexseek() would be a better function for this. The lookup() function is not Rushmore optimized.