>Before you get too carried away with TABLEUPDATE(), it looks like you might want to use DELETE ALL as indicated above. Remember that the default scope for DELETE is NEXT 1, so unless the record pointer happens to be on the record you want to delete in tables 2 and 3, nothing will happen.
>
Actually the FOR clause replaces the ALL scope in the delete. All records that apply to the criteria will be deleted. If a WHILE clause were usede and the record pointer was not sitting on a record that applied, then no deletes would take place.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao