Select Database Options for a Relationship

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

  1. On the Microsoft English Query Semantic Objects tab, select Relationships, and then double-click an existing relationship.
  2. On the Database tab, select a table from the Table that contains links to all entities in this relationship box. As an alternative, you can have Microsoft English Query find that table by clicking Calculate Default Join Table.
  3. If you want to specify when the relationship is true, enter an appropriate SQL condition. For example, the relationship is: products are shipped to customers. The SQL condition is a requirement that customers’ credit be approved:

    4. Approval= 'T'

  4. Click Apply.

(c) 1996-1998 Microsoft Corporation. All Rights Reserved.