The “Relationships” form lets you define a link between any two database tables, providing the tables contain one or more identical columns (called Match fields). When tables are related, you can combine data from these tables in a form or report and use the DataEase lookup feature to automatically enter data in record entry forms built over these tables.

1. Choose menu option: Application>>Relationships. DataEase displays the “Relationships” form;

2. Click the drop-down arrow to the right of the field beneath “Records in”. Choose the name of the database table for the first form. Press <Tab>. Click the drop-down arrow beside the next field, and choose the name of the second table. Press <Tab>;

3. Enter the Match field(s) on which the relationship is based;

4.  Click the drop-down arrow, choose the name of the Match field for the first form in the first column, and press <Tab>;

5.  Click the drop-down arrow, choose the name of the second Match field, and press <Tab>;

6. Enter any other pairs of Match fields you want to use;

7. Type the Custom Relationship Name (optional, but recommended);

8. If the two forms constitute a Multiform, choose the Referential Integrity option in the Referential Integrity field (under the Sub-form table name);

9. Click <Save> at the bottom of the Relationships form, and then click <Done> to close the form.