I have parent and child tables - both with pessimistic row buffering. Based on changes to a record in the parent table, I issue an UPDATE SQL statement to update child records [on multiple fields]. Do I need a TABLEUPDATE command after the UPDATE? Should I use a TRANSACTION to avoid record locking problems?

Thanks,
Doug