000029864 - Sub-form field will not display as a column within Related Record table in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 26, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000029864
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 6.x
IssueSub-form fields can be added to a Related Record field, however, when viewing the record this column will not display within the table.


In this example, the Comment field of a Questionnaire's Comments Sub-Form is being added as a column for the Related Record table:
Add Comments Field

When the record is viewed, the Comment field is omitted from the Related Records table:
Related Records Results
CauseSub-form fields will be omitted from Related Record columns due to the fact that there could be multiple instances of the field within a single record. This makes displaying the field within the table unfeasible as the number of potential results can be variable.
WorkaroundA separate field outside of the Sub-form should be used in place of the Sub-form field. This will limit the field to a single entry and will allow Archer to use this as a column within the Related Record table.