How to change the table options for a relationship

Change the table options for a relationship to calculate or identify the table that contains all the links to the tables (join table) represented by entities, or to specify a condition for when the relationship is true.

To change the table options for a relationship

1. On the Semantics tab, expand Semantic Objects.
   
   
2. Expand Relationships, and then double-click the relationship whose table options are to be changed.
   
   
3. On the Database tab, select a table from the Table that contains joins to all entities in this relationship box.

   As an alternative, have English Query find that table by clicking Calculate Default Join Table.

4. To specify when the relationship is true, select This relationship is true only when the following SQL condition is true and enter an appropriate SQL condition.

   For example, if the relationship is products are shipped to customers and the SQL condition is a requirement that customers' credit be approved, type:

   Approval= 'T'
   

5. To have English Query answers generated from the most recent data in the database, select Show most recent data by default.

See Also

Database Tab (Relationship/New Relationship Dialog Box)

Model Editor

Relationship/New Relationship Dialog Box

Semantics Tab (Model Editor)