ApplicationsEdit Data in a Cross Reference Table

After a cross reference table is created, you can use the View Data page of the XrefUserApplication or the XrefAdminApplication (depending on your permissions) to insert, update, or delete rows and data in the table. You can also search and View Data in a Cross Reference Table, Import Data to a Cross Reference Table, and Export Data from a Cross Reference Table.

To access the View Data page, perform the following steps:

  1. In Applications , open the Cross Reference Table App folder and do one of the following:
    • If you do not have administrative permissions, select the XrefUserApplication.
    • If you have administrative permissions, select the XrefAdminApplication, and then click View Data.
  2. Next to View Data, select a table from the drop-down list. The names of the columns in the table are displayed. To view the contents of the table, see Search for Data in a Table.

Insert Row

To add a row to a cross reference table, perform the following steps:

  1. On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
  2. Under Edit Data, enter data in the fields for each column as needed.
  3. Under Insert Row, click Insert. A message is displayed in the log pane confirming the inserted row.

Note: The data displayed for a table in the View Data page is not dynamically updated. To view updated data, perform a new search on the table. For more information, see Search for Data in a Table.

Update Row

To modify the contents of a row in a cross reference table, perform the following steps:

  1. On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
  2. Under Edit Data, enter the ID of the row you want to edit and then click Load. The data for the row is displayed in the fields for each column below.

    Tip: If you do not know the row ID, perform a search for the row and obtain the ID. For more information, see Search for Data in a Table.

  3. Modify the data in the fields for each column as needed.
  4. Under Update Row, click Update. A message is displayed in the log pane confirming the updated row.

Note: The data displayed for a table in the View Data page is not dynamically updated. To view updated data, perform a new search on the table. For more information, see Search for Data in a Table.

Delete Row

To delete a row from a cross reference table, perform the following steps:

  1. On the View Data page, select a table from the drop-down list. The names of the columns in the table are displayed.
  2. Under Edit Data, enter the ID of the row you want to edit and then click Load. The data for the row is displayed in the fields for each column below.

    Tip: If you do not know the row ID, perform a search for the row and obtain the ID. For more information, see Search for Data in a Table.

  3. Under Delete Row, click Delete. A message is displayed in the log pane confirming the deleted row.

Note: The data displayed for a table in the View Data page is not dynamically updated. To view updated data, perform a new search on the table. For more information, see Search for Data in a Table.