Create a many-to-many table relationship

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 2분

    • Create a bi-directional relationship between two tables, so that the related records are visible from both tables in a related list.

    시작하기 전에

    Role required: admin.

    이 태스크 정보

    Many-to-many relationships allow a list to point to a list of entries, rather than to single field.

    If a knowledge base article points to a list of related configuration items, it uses a related list. Not all lists can be used as related lists, however. For a list to be related to another list, a many-to-many relationship that refers to both tables must exist.

    The Many to Many Definitions [sys_m2m] table allows administrators to create custom many-to-many relationships.

    Many-to-Many tables aren't considered custom tables and don't count toward your custom table allotment.

    프로시저

    1. In the navigation filter, enter sys_m2m.list.
    2. Click New.
    3. In the From table field, specify a parent table.
    4. In the To table field, specify a child table.
      The Many-to-Many form automatically populates the other fields with suggested values.
    5. 옵션: Edit other field values, if appropriate.
      주:
      Many-to-Many table names cannot exceed 30 characters.