Create a Relationship

Relationships describe what the entities have to do with one another. You can use the Insert Relationship command to define a new relationship in a project. For example, when you’ve added a join to your database structure, you might want to create a relationship that requires that join.

Defining relationships and their phrasings is necessary because there are many ways to describe an association between objects in English. For example, customers buy products from salespeople and salespeople sell customers products both describe an association that is supported by underlying joins between the Customers table, the Products table, and the Salespeople table.

1. On the Microsoft English Query Insert menu, click Relationship.
2. On the Entities tab, click Add Entity. For more information about adding an entity, click .
3. On the Phrasings tab, click Add. For more information about adding phrasing, click .
4. On the Database tab, select a table from the Table that contains links to all entities in this relationship box.
5. If the relationship is related to a particular time or location, click the Time/Location tab and make the appropriate selections. For more information about time and location, click .