, ,

---

The deletechildren statement deletes all the records in another database that have a value in the key field that is equal to the key value.

---

Parameters

This statement has three parameters:

database – Name of database containing the “child” records.

keyfield – Name of the field you want to search in.

keyvalue – Value in records to be deleted.

---

Description

This statement deletes all the records in another database that have a value in the key field that is equal to the key value. Note: As a side effect, all remaining records in the target database will be selected.

This example deletes all the records from the My Contacts database that have the value "Acme" in the Organization field. It will not delete a record which contains "Acme Holdings".

DeleteChildren "My Contacts", "Organization", "Acme"

---

See Also

• deleterecchildrenwarn -- warns you before deleting the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
• deleterecordandchildren -- This deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
• post -- assigns a value to a field in another database.
• postadjust -- adjusts the value of a numeric field in another database, by adding (or subtracting) a number.

---

History

Version	Status	Notes
10.0	No Change	Carried over from Panorama 6.0.