Essential ADO.NET

B.5. Parent/Child Relation Referencing

A column in a child table may be referenced in an expression by prepending the column name with “Child.” For example, “Child.Price” would reference the column named Price in the child table.

If a table has more than one child, the syntax is: Child(RelationName). For example, if a table has two child tables named Employee and Titles, and the Data-Relation objects are named “Publishers2Employee: and “Publishers2Titles,” the reference would be:

Child(Publishers2Employee).fname
Child(Publishers2Titles).title

A parent table may be referenced in an expression by prepending the column name with “Parent.” For example, the “Parent.Price” references the parent table's column named “Price.”