Takes two parameters, ChildTableName, Mode


The Alias of Attached Children Records will be added to the Query, using the specified mode. If more than one Parent Table exists in the Query, Child Records will be matched to any and all of the Parent Tables. So if you have 2 Parent Tables in the Query, the number of children would be doubled.

It is important to note that the regular Children and Parents commands confirm that a records exists while joining the data and if an attachment exists for a non-existent record it does not load that attachment. In contrast, for ChildrenAlias and ParentsAlias, because the record data is not read, it is unaware if the records actually exists or not. Therefore, attachments to non-existent records will be loaded.

Mode must be one of: "All", "One", "Discard"


SetNew      "MemTab.Person.Alias", ($SessionUser)
Children "ToDo.List"
Children "ToDo.Item"
KeepIf "ToDo.Item.Alias", =, `pItem

 *Note: "All" is used as default mode when no mode is provided