Click above to get retro games delivered to your door ever month!

  Indexes are used to help users find data quickly, and also to allow you
  (the programmer) to set up relationships between data files.

  The Dictionary provides room to store 4 types of information about each
  index:

    1) the prompt to use in the "Find" routine.

    2) the actual index key.

    3) the index type:

           Primary: this index uniquely identifies each record,
                    i.e. the Order_No index on the Orders file

           Foreign: this index is based on a value which is
                    unique in another table, i.e. the
                    Account_No index on the Orders file

           Secondary: a non-unique index on any field, i.e.
                      the CompanyName index on the Customer
                      file

    4) was SET UNIQUE on when the index was created? If so, the
       index will be maintained correctly.

  You don't have to bother creating your indexes: just list them in the
  Dictionary and the first time your program runs, all required indexes will
  be created.