>>>>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.
>
>I don't see indexseek in vfp5.

Sorry, new feature in VFP6. I didn't read your post very well. The idexseek function will return logical if a value is found in a table. The nice part is it won't move the record pointer if you don't want it to, and you do not have to be sitting alias your are doing the seek in. This is useful becuase triggers won't be fired.