Application Development (the resource worksheet file) Step 3 The first step in modification of the primary worksheet was to create a menu through which detailed information on the resource could be retrieved. The macro that was used to create the menu structure is &MENU. The &MENU macro must be located in the worksheet so as not to interfere with the areas that are used for resource information fields. For the NPS/MORA application, the menu macro was placed in cell [K2] of the "MORA.CRS" (primary) worksheet. The assembly of the menu that was to control access to the information in the secondary worksheet began with specification of menu selection choices. These choices were placed in a column in adjacent rows in the worksheet. The entries that were be included in the NPS/MORA resource record menu are: A. Profile B. Historic Significance C. Maintenance Management D. Site Description E. Special Conditions F. Image Processing G. Return to Main Level "Profile" was placed in cell [O2], "Historic Significance" in [O3], "Maintenance Record" in [O4], "Site Description" in [O5], and "Special Conditions" in cell [O6]. The macro statement implementing a return to the "Main Level" (primary worksheet) of the resource management application to begin a new search was placed in cell [O7]. The macro statement to "Quit System" and terminate the execution of the resource management application was placed in [O8]. The contents of the &MENU macro statement located in cell [K2] is as follows: &MENU(O2,O8,M2,50,7,3,1,RESOURCE RECORD) [&MENU] The label that defines the "menu" macro. [02] Defines cell [O2] as the first entry in the menu. [O8] Defines cell [O8] as the last entry in the menu. [M2] Defines [M2] as the cell location in which the response from the menu selection is placed. If menu item "A" is selected, a value of "1" is placed in cell [M2], if "D" is selected, a value of "4" is placed in [M2]. [50] Corresponds to the horizontal coordinate of the menu location on the worksheet display screen. This number (50) places the upper left hand corner of the menu 50 characters from the left margin of the worksheet. [7] Specifies the vertical coordinate of the menu location on the worksheet display screen. This number (7) places the upper left corner of the menu 7 rows below the top row of the worksheet. [3] Foreground color assignment from the color table: 0 = Black 8 = Dark Gray 1 = Blue 9 = Light Blue 2 = Green 10 = light Green 3 = Cyan 11 = Light Cyan 4 = Red 12 = Light Red 5 = Magenta 13 = Light Magenta 6 = Brown 14 = Yellow 7 = Light Gray 15 = White [1] Background color assignment from the color table (Same color table as Foreground color). [RESOURCE RECORD] This specifies the title label that will be placed at the top of the menu. Index to the Appendices Application Development 2. Application Development 4.