Hi Dean,

>What is a proper way to update both parent and child table with one local view? or is this not possible...

I wouldn't recommend doing that in one view. This will cause unpredictable results, since VFP has no specific order in which changes are being saved. Even more problems will occur when you try to add new records. To be save, make two views and update them separately.

Regards,
Armin