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