Document ID field

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：2分

    • You can create document ID fields to reference any record on any table.

    始める前に

    Role required: personalize_dictionary

    このタスクについて

    In comparison, a reference field references a record on a specific table. To reference records from any table, two fields need to work together—one to store the table reference and another to store the record reference.

    You can select the document ID type when creating a new field.

    手順

    1. Navigate to the form view for the table.
    2. Right-click the header and select Configure > Form Layout.
    3. Create a field to store the table name and click Add.
      • Name: Any label (for example, Model table)
      • Type: String
    4. Create a field to store the record reference and click Add.
      • Name: Label for your document ID field (for example, Model ID)
      • Type: Document ID
    5. Click Save.
    6. Right-click the form header and select Configure > Dictionary.
    7. Open the dictionary entry for the document ID field.
    8. Under Related Links, click Advanced view.
    9. In the Dependent field, enter the column name of the table reference field (for example, u_model_table).
    10. オプション: In Attributes, add the show_all_tables dictionary attribute to display system tables.
    11. Click Update. When users click the reference lookup for the document ID field, a dialog appears that allows them to select the table and then the record. The sys_id of the selected record is stored in the document ID field and the table name is stored in the table reference field.
    12. オプション: Configure the form to remove the table reference field.
      Document ID