I have a parent table called arc_person and child table called arc_pinfo. There is a relation (in data environment) between the two tables though field called personid. My problem is when I issue a "Delete From" command, it only delete item from one table (parent table) but not from child table. Here is the following code:

	nAnswer = MESSAGEBOX("Are You Sure You Want This Record Deleted", nDialogType, "Delete This In-Active Record")

	DO CASE
		CASE nAnswer = 6	&& WAIT WINDOW 'You chose Yes'
			delrecno = arc_person.personid
			delete from arc_person WHERE arc_person.personid = delrecno
			TABLEUPDATE(.T., .T., "arc_person")
			delete from arc_pinfo WHERE arc_pinfo.personid = delrecno
			TABLEUPDATE(.T., .T., "arc_info")
			.release()

Has anyone run into this problem too?

Thanks
Nick Patel