ASTRO AstroJet 2000, Installation, Operating, And Parts Manual

Page: 36 / 62

32
3. Click the “Design” button. A window displaying the characteristics of each field
(column) in the database is drawn.
4. Select the first row by clicking in the blank gray square to its left. This selects the
characteristics of first column.
5. At the bottom left click in the cell to the right of the heading “Allow Zero Length” to
display a drop down arrow, from which you will select “yes”.
6. Click the cell to the right of the heading “Indexed” to display a drop down arrow, from
which you select “Yes (Duplicates OK)”
7. Exit Access.
Indexing a dBase III, IV, V, FoxPro (*.DBF) File
To index a dBase file for use with the Layout Editor and Control Panel you will need
Microsoft FoxPro. This should be installed on the target system to ensure the same leave of
ODBC is available to Access and the Layout Editor and Control Panel. Then follow this
procedure:
1. Start FoxPro and open the database file, (for example: “SAMPLE.DBF”.
2. Select the table to be used - here it is “SAMPLE”.
3. If you are asked about the character set to use, select 1252 – Windows ANSI.
4. From the “View” menu select “Table Designer”. A tabbed dialog wills popup.
5. Select the “Fields” tab. Note the name of the first field. Select the Indexes tab.
6. In the cell under Name, type the name for your index. In this case “SAMPLE”.
7. Once this is entered other fields become available. Fill in the following fields:
A. Order – click to show an up arrow (ascending)
B. Type – select regular
C. Expression – enter the field name you noted above
D. Filter – leave blank
8. Click “Okay” and “Yes” to make structures permanent.
9. Exit FoxPro.