Viewing columns of a parent table

Use this procedure to view all the columns that belong to the same parent table of a selected table column. Before you start, you must complete a table search task.

  1. On the Search Results tab, click a Parent Table name.
    A new search result opens with the header Table Relation Type: Total match.
  2. On the Parent table column, click an item across the column name of your selection.
    A new search result opens with this information:
    Column Name
    The name of the column used by your selected table.
    Description
    The description of the column used by your selected table.
    Data type
    The data type of the column used by your selected table.
    Length
    The length column used by your selected table.
    Decimals
    The decimals of the column used by your selected table.
    Edit Code
    The edit code of the column used by your selected table.
    Indexes
    The edit code of the column used by your selected table.
  3. Use these options to sort and filter your results.

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, specify a dynamic free text filter for each column and select a Filter action.