In a Relationship Designer window, choose the two views you want to join in the corresponding combo boxes. Use the Add, Edit and Delete buttons to modify the join conditions. Editing a join condition in the Join Condition Editor dialog box, choose a field of the first view in the Field1 combo box, a field of the second view in the Field2 combo box, and the join comparison operator in the Operator combo box (in most cases you will use the equality '=' operator in joins). In advanced cases where you need an expression in a join, you can check the Use expression in right part check box and enter an expression instead of Field2. In an expression, use SQL syntax for functions and operators, and the following syntax for fields:

[view_name]![table_name].[field_name]

In even more advanced cases, if you need to join tables using a more complicated condition that cannot be expressed in terms of simple joins between fields of the participating views, check the Use SQL condition check box. In this case the join is just a single string that represents the entire SQL condition. Use regular SQL syntax in the condition, and the same syntax for fields as above:

[view_name]![table_name].[field_name]

Copyright (c) GrapeCity, inc. All rights reserved.