Look Up Tables

Lookups are reference tables in which data is stored for many different options, drop lists, and selections in the Association Database.

To find a Lookup:

  • Click on Lookup from the left menu
  • Select the Lookup Type
  • Click Go

To Create a New Lookup:

  • Click on Lookup from the left menu
  • Click on New in the top right corner of the screen
  • Select the Lookup Type, or enter a new one
  • Enter an Index number (this should be a number greater than the last number used, if not new)
  • Enter a Description (this is the name of the Lookup)
  • Enter a Numeric Value (if applicable)
  • Enter a String Value (if applicable)
  • Enter an Application Value (if applicable)
  • Enter an Order level (this is the order in which this option will be displayed, use increments of 10)

To Add Content to a Lookup

  • Select the desired lookup
  • Click the Go button
  • Click the Add link
  • Enter an Index number (this should be a number greater than the last number used, if not new)
  • Enter a Description (this is the name of the Lookup)
  • Enter a Numeric Value (if applicable)
  • Enter a String Value (if applicable)
  • Enter an Application Value (if applicable)
  • Enter an Order level (this is the order in which this option will be displayed, use increments of 10)