Show report link only if records exist(no table relationship)
I have an audit log for when poles are taken are taken out of or put in a work request. I have 3 tables associated with this: Work Request table, Poles table, and Audit Log table. The audit logs capture "Old WR" and "New WR."
The table relationships I have are between the <Work Request table and the Poles table> and then between the <Poles table and the Audit Log table> referencing related pole#.
The Poles table form report links to all the logs with the related pole. The Work Request table form has two report links in their own section called "Pole History" - the first showing poles added to the Work Request three days after the initial work request creation and the second showing poles taken out of the Work Request.
My question is: How can I collapse the "Pole History" section when there are no records in the report links? I know I will have to use form rules for this, but report links aren't values, so I don't know how to set up the criteria for hiding the section.
The table relationships I have are between the <Work Request table and the Poles table> and then between the <Poles table and the Audit Log table> referencing related pole#.
The Poles table form report links to all the logs with the related pole. The Work Request table form has two report links in their own section called "Pole History" - the first showing poles added to the Work Request three days after the initial work request creation and the second showing poles taken out of the Work Request.
My question is: How can I collapse the "Pole History" section when there are no records in the report links? I know I will have to use form rules for this, but report links aren't values, so I don't know how to set up the criteria for hiding the section.
