Delete them from a single table view or use SPT. This way you'll have full control over wich tables are affected.

>In a multitable view, I am finding that on deleting a record, even the parent table records are getting deleted. Could anyone tell me how to do this so that only a particular table - child or parent record is deleted, leaving the others as they are?