Contents - Index

Tour Finder and Destination Codes

Tour Finder Tab is located behind the Add a Reservation tab and is an interface designed to help locate tours that meet entered criteria. Tour Finder lets you search tours  by: 
  • Date range
  • Destination (user defined)
  • Descriptor (user defined)
    The steps to set up are:
    1. Decide how you will code your tours (as what category each code will belong to.) For example 
      a. Code Category is City and Codes are Paris, London, New York
      b. Code Category is Focus and Codes are: Art, Gardens, History, General
       c. Code Class is Activity Level and Code Class is Easy, moderate, strenuous.
        
    2. Create these codes in code table under Destinations (see Adding Destinations/Descriptors to Look Up Code Table) You can create and assign as many categories as you wish. However, tour finder allows you to search by three categories at a time.

    3. Assign the destinations and descriptors to each tour. (Enter codes consistently or your search/report filters will miss tours.  A good rule is to decide how many categories you wish to track, and be sure that each category is assigned to every new tour.)
    Before you decide how to code your tours, you will want to understand how the tour finder gives results. 

    The search function returns "ors" with in a column and "ors" between columns. (Access is unable to do an "and" search.) 
    So if for category of city you select Paris and London, the results will show all tours to Paris and/or London.  (An "and" search would return only tours to Paris and London in the same trip.)
    Results are sorted by "hits," so tours meeting the most criteria will appear at the top.  

    If you had London and Paris selected in a city search and added "Art" as a value in another column, your results would be all tours that had been assigned one of these values. The tour with the most hits (an Art tour to Paris and London=3 hits) would  appear first on the list.

    You can find out more about the tour by double clicking on the tour name, which is a short cut to the tour form.

    You can also create multiple reservations for one traveler using this form.