Assigning a field value by setting a constant value during field mapping

Selecting the Has constant value set to option on the Field Mapping dialog box allows you to define a constant value for the field.

Steps:
  1. Verify that you are in layout view if necessary.
  2. Right-click the graphic table element and click Properties.

    The Table Properties dialog box appears.

  3. If necessary, click the Data Source tab.

    The Data Source tab appears.

    Data Source tab
  4. Click a data source in the Data Source list on the Data Source dialog box.

    The selected data source is highlighted, and the Field Mapping button becomes available.

  5. Click Field Mapping.

    The Field Mapping dialog box appears.

    Field Mapping dialog box
  6. Check the Display coded value descriptions check box if you want coded value descriptions to display in the table.
  7. Click the Field drop-down arrow and choose the field you want to map.
  8. Check the Show Field Aliases check box if you want field alias names to display in your table.
  9. Click the Has constant value set to option if you want to assign a constant value to the table field.
  10. Type a specific value in the text box.
  11. Click OK.

    The Table Properties dialog box appears.

  12. Click OK.

6/14/2012