A parent field is prepended with "Parent(relation_name).". For example, Parent(Customers – Orders).CustomerName used in the Orders table references the CustomerName field of the Customers table. If there is only one relation connecting the tables (or table views), the relation name can be omitted. Example: Parent.CustomerName

A child field is prepended with "Child(relation_name).". For example, Child(Customers – Orders).OrderDate used in the Customers table references the OrderDate field of the Orders table. If there is only one relation connecting the tables (or table views), the relation name can be omitted. Example: Child.OrderDate