Article Content
Article Number | 000029864 |
Applies To | RSA Product Set: Archer RSA Product/Service Type: Archer RSA Version/Condition: 6.x |
Issue | Sub-form fields can be added to a Related Record field, however, when viewing the record this column will not display within the table. Example: In this example, the Comment field of a Questionnaire's Comments Sub-Form is being added as a column for the Related Record table: When the record is viewed, the Comment field is omitted from the Related Records table: |
Cause | Sub-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. |
Workaround | A 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. |