Adding a table as dynamic text using a field as a text string

Inserting Table dynamic text allows you to display the attributes from a table within your map or source database. You first select the table you want to use. After selecting the table, you can specify a specific attribute field to display using filtering and query options. With table dynamic text, you can query and use table values from any table you can access in ArcMap.

You can display an attribute field by using a SQL query to choose field values or you can create a script that returns the attribute or attribute field value you want displayed.

Selecting the Field text string option on the Map Sheet Dynamic Text Properties dialog box allows you to specify a specific attribute field to display as dynamic text.

Steps:

1. Start ArcMap.
2. On the main menu, click Customize > Toolbars > MPS Atlas.
3. Click the Add Dynamic Text button on the MPS Atlas toolbar.

   A crosshair with a letter A appears.

4. Click anywhere in the map sheet layout.

   A piece of dynamic text is inserted on the page.

5. Double-click the dynamic text.

   The Dynamic Text Properties dialog box appears.

6. Click the Dynamic Text tab if necessary.
7. Click the Dynamic Text drop-down arrow and choose Table.
8. Click Insert.

   The table text appears in the text box.

9. Click the dynamic text element in the text box.

   The Table Dynamic Text Properties dialog box appears.
10. Click the Browse button to navigate to the table you want to use.
11. Click Select.

    The path to the table appears in the Table text box. A field name appears in the Field drop-down list.

12. Click Query Builder if you want to specify attribute field values to display.

    The Select Features Using a Query dialog box appears.

13. Create a SQL expression to display the attribute field values you want displayed.

    Learn more about creating a SQL expression

14. Click OK when you are finished creating the SQL query expression.

    The Table Dynamic Text Properties dialog box appears.

Note:

Clicking Clear on the Table Dynamic Text Properties dialog box allows you to delete the SQL query expression you created without having to reopen the Select Features Using a Query dialog box.

15. Click the Field option.
16. Click the Field drop-down arrow and choose the attribute you want to display.
17. Click OK.