Town table 

    This is the list of towns for use in address combo boxes where the user needs to enter a town. The database has one field for the name of the town, one field for the state and one field for the default zip code for this town (for small towns).

    When you click on the drop down menu "Towns..." under "Tables", a dialog window like the next one will appear:
 

In this window, you find the following controls:

Modify button

     Once granted the appropriate right, select the table record and click the "Modify..." button or double click the line where your selection is and a dialog box will appear to modify the records. The ID "Code:" cannot be changed; too much data is linked to this ID to permit a change. Be sure to click the "Save" button in order to secure your change.
 

     The state field is to identify 2 towns with the same name, but in different states. ex.: Springfield. The zip code field is for small towns where there is only one zip code for the whole city. This zip will code will be used as default in data entry. If there is more then one zip code in the town, leave it blank.

Add a Town...

     You can add a table record by clicking on the "Add a Town..." button at the bottom right corner of the window.
 

  The "Add a Town..." button is similar to the "Modify" button, but it will bring up a dialog box with empty fields. From there, you can use "TAB" or "Shift + TAB" to move to the next or previous field.

     The Code ID MUST be unique and therefore will be automatically supplied by FertiSoft and will not be editable. Once you've completed the information, click "Save" and  your table record is created. Now you can view t his record under " Table Maintenance" data browser.

Close this window

     The Quit button is used to close the table maintenance dialog window. It is located just to the right of the "Add" button. It acts in the same manner as the " X " in the upper right corner of the window.

Data browser

     The data browser is the data container where you can browse the table records. It contains column for IDs and descriptions. You can navigate in the database and find the record you are searching for. Once you found it, you can select it with your mouse. Or you can double click on it to activate the "Modify" function for this record. When you change the display order, the column header that the order is active will turn yellow.

Listing

     You can print a table listing by clicking on the "Listing..." button. First, you need to confirm the printer that will be used if you print the listing. This is done in the Choose printer dialog window. This is useful if you want to change the target printer or change some of the printing parameters (See Printing Dialog). After pressing the "OK" button, the process will build the listing in the computer memory. FertiSoft will bring you to the print preview screen where you can visualize the listing as if it were on paper. From this preview, you can then decide to print it on paper or not.

     The layout on this listing is data retrieved from the table database. You have useful information on this listing, from left to right:

• Code ID
• Descriptions
• State
• Default zip code

     For complete information on how the preview window works, See Preview Window.