<Role Name>Role Dialog Box

English Query

English Query

<Role Name>Role Dialog Box

Use this dialog box to add entities to a new relationship or to modify entities in an existing relationship that does not have command phrasings.

Note  <Role name> is the name of the role, not the name of the entity.

Options

Always display <entity>

Specify that the entity is always displayed whenever the relationship is used, whether or not the question suggests its use.

For example, you can select this option from the salesperson role in the customers buy products from salespeople relationship. In response to the question, "Who bought a hammer yesterday?", English Query shows the salesperson who sold the hammer in addition to the person who bought it.

How many

Select any entity in the model whose entity type is Measure.

It indicates that the quantity of the role entity used in the relationship is indicated by another entity chosen from this list. This allows English Query to answer questions such as "How many products did xxx buy," when each purchase consists of a quantity greater than 1.

Note  Select either How many or How much, but not both for a role.

For example, in the relationship, customers buy products from salespeople, the product role entity can be quantified by the entity, sales quantity, that was chosen from this list. This allows English Query to answer the question, "How many products did John buy," with a response of five, if John bought 2 boxes of Chai and 3 boxes of tea.

How much

Select any entity in the model whose entity type is Measure.

Note  You can select either How many or How much, but not both for a role.

For example, the product role in the customers buy products relationship can be specified by selecting the sales amount entity. This enables English Query to answer the question, "How much cheese did Quick-Stop buy" and get an answer in terms of the sales amount in dollars.

Join Path

Use the join path that currently exists between the join table and the table or field that represents this entity.

Specify

Display the Specify Join Path dialog box, where the join path can be changed. Specify a join path when there is more than one way to get to the entity from the join table specified for the relationship.

See Also

Entities as Roles

Specify Join Path Dialog Box