More about connectors

Whenever you add more than one criterion to report or filter on, you must assign a connector to show the relationship between the two.

Inform supports 4 connectors:

• And: Both criteria must be met on each record for it to be returned. Use And when you are joining multiple properties of a record, such as
• Salesperson = John Smith

AND 

• YTD Sales > 100,000.

returns all customers of John with sales over 100,000.

• And with: Designates a grouping of criteria in which criteria for both groups must be met.
• YTD Sales > 100,000

AND WITH

• Salesperson = John Smith

OR

• Salesperson = Mary Smith

returns customers with over 100,000 in sales that have either John or Mary as the salesperson.

• Or: One of the criteria must be met for the record to be returned. Use Or when you want to return records that meet at least one of the criteria, such as
• Salesperson = John Smith

OR 

• Salesperson = Mary Smith

returns customers with either John or Mary as their Salesperson

• Or With: Designates a grouping of criteria with OR between groups
  • Last Year Sales > 100,000
  • AND
  • Salesperson = John Smith
  • OR WITH
  • Salesperson = Mary Smith
  • returns customers with John as a salesperson and over 100,000 in sales, or all customers with Mary as a salesperson regardless of last year sales.