States table 

    This is the list of states for use in address combo boxes where the user needs to enter a state. The database has one field for the name of the state. It can be regions, department or provinces in countries where there is no state.

    When you click on the drop down menu "States..." 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:" can be changed, but must reflect the real abbreviation of a state. It must be unique. The state table supplied with FertiSoft already have 72 states, territories and provinces.. Be sure to click the "Save" button in order to secure your change.
 

Add a State...

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

  The "Add a State..." 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 you have to make sure you don't create it twice. 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

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