Working with an ArcPad AXF file in the Tree View

In ArcPad Studio, ArcPad AXF files are displayed as a tree diagram that relates to the schema, data, and relationships in the ArcPad AXF database. The tree contains three main branches: Feature Layers, Feature Tables, and Data Tables. It also has two other branches: Files and Properties. You can interact directly with the tables and schema of the ArcPad file in the Tree View.

Viewing the contents of a table

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the table containing the contents you want to view.
3. Click Show Data.

Executing a SQL command

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, double-click the root element (the top element that displays the name of the AXF file).
3. Type the Structured Query Language (SQL) command in the SQL Command window.
4. Click Execute.

   The results of the SQL command are displayed in the lower pane of the SQL Command window.

Creating a feature layer

In an ArcPad AXF file, you can have multiple feature layers based on a single feature table. The underlying data comes from the feature table but is represented differently (for example, different edit forms, symbology, and so on) by each feature layer referencing it.

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the existing feature layer or feature table for which you want to create a new layer.
3. Click Create New Layer.
4. Type a name for the new layer.

Deleting a feature layer

Deleting a feature layer does not delete the associated feature table; however, you can only open feature layers (not feature tables) in ArcPad.

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the existing feature layer you want to delete.
3. Click Delete.
4. Click Yes in the warning message.

Deleting a feature table

Deleting a feature table deletes all the feature layers that are associated with that feature table.

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the existing feature table you want to delete.
3. Click Delete.
4. Click Yes in the warning message.

Renaming a feature layer

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the existing feature layer you want to rename.
3. Click Rename.
4. Type the new name and press Enter.

Setting a layer icon for a feature layer

Layer icons are displayed next to the layer name in various places in ArcPad (for example, in the Start/Stop Editing list; on Edit, Identify, and Query forms; in the Table Of Contents, and so on).

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the existing feature layer where you want to set the icon.
3. Click Set Layer Icon.
4. Navigate to the .ico file you want to use, and click Open.

Clearing the layer icon of a feature layer

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the existing feature layer that has the icon you want to clear.
3. Click Clear Icon.
4. Click Yes in the warning message.

Editing the layer definition of a feature layer

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, right-click the feature layer with the layer definition you want to edit.

   You can also double-click a layer in the Feature Layers branch of the Tree View to edit the layer definition.

3. Click Edit Layer Definition.

Making a table field read only

Read-only fields cannot be edited in ArcPad in an Edit Form or Feature Properties dialog box.

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, expand a feature table or data table from the Feature Tables branch or Data Tables branch, respectively.
3. Expand the Columns branch.
4. Right-click the field you want to make read only.
5. Click Read Only.

Hiding a table field

Hidden fields are not displayed in ArcPad in an Edit Form or Feature Properties dialog box, or in the Find dialog box.

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, expand a feature table or data table from the Feature Tables branch or Data Tables branch, respectively.
3. Expand the Columns branch.
4. Right-click the field you want to hide.
5. Click Hidden.

Setting singular and plural table names for display

Singular and plural object names are used for related table counts in the Feature Properties dialog box. For example, if the table name is LightInspections, you can set the singular object name to "Light Inspection" and the plural object name to "Light Inspections".

Steps:

1. Open an ArcPad AXF file.
2. In the Tree View, expand a data table or feature table that has a child relationship (it will display Relationships (Child)).
3. Expand the Relationships (Child) branch.
4. Expand the foreign key branch to display the table name.
5. Right-click the table.
6. Click Singular Object Name to set the singular display name, or click Plural Object Name to set the plural display name.
7. Type the desired name and click OK.