Modifying the Options in the Drop Down Lists

The drop down lists for the 1st, 2nd and 3rd code boxes are established on the Codes tab in Gopher Options.  The fields can be defined on the Captions tab in Gopher Options.

The drop down list that appears for ‘Current position and any position qualified for’ (Applicant) and ‘Functional Title’ (Client) is taken from the 1st code box.  For this reason, you may want to define the 1st Code Box as Job Title Codes.

The options that appear in the remaining drop down lists are established in the cds table in your Gopher database. 

Note:  Changing the options requires you to open your database in MS Access in order to modify the cds table.  If you are not familiar with MS Access and therefore do not feel comfortable making changes to the database, please contact BlackDog Recruiting Software for assistance. 

In order to modify the options that appear in the drop down lists, follow the steps outlined below:

1. Gopher should be closed on all computers on your network.

2. Be certain you have a recent backup of your Gopher database.  If you do not, make a copy of your database as a temporary backup.

3. Open your go4\mdb\go4.mdb database in MS Access.  This database resides on your local drive and is linked to the database on the server.

4. Open the cds table.  If the data is not in numerical order by ‘Cdsty’, RIGHT click on the heading ‘Cdsty’ and click ‘Sort Ascending’.

5. The options that appear in the Source drop down list for both Applicants and Clients are the same.  The ‘Cdsty’ for the Source options is 15.  You may change the Description as applicable, delete rows if they are not needed, or add new rows to add additional options for Source.  Be certain that the ‘Cdsty’ is 15.  The Code (‘Cdscd’) has a minimum length of 1 and maximum length of 4.

6. The Box 0 options for Applicants have a ‘Cdsty’ of 9.  If new options are added for Applicant Box 0, be certain to type 9 in the ‘Cdsty’ column.

7. The Box 1 options for Applicants have a ‘Cdsty’ of 10.  If new options are added for Applicant Box 1, be certain to type 10 in the ‘Cdsty’ column.

8. The Box 2 options for Applicants have a ‘Cdsty’ of 11.  If new options are added for Applicant Box 2, be certain to type 11 in the ‘Cdsty’ column.

9. The Box 0 options for Clients have a ‘Cdsty’ of 12.  If new options are added for Client Box 0, be certain to type 12 in the ‘Cdsty’ column.

10.    The Box 1 options for Clients have a ‘Cdsty’ of 13.  If new options are added for Client Box 1, be certain to type 13 in the ‘Cdsty’ column.

11.    The Box 2 options for Clients have a ‘Cdsty’ of 14.  If new options are added for Client Box 2, be certain to type 14 in the ‘Cdsty’ column.

12.    When you have finished modifying the cds table, close the database and close MS Access.  If you receive a message asking if you would like to save layout changes, click No (although it will not hurt to click Yes).  All modifications that were made to the data in the cds table, were saved immediately.