Forum Discussion

JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
7 years ago

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 captu...
Forms
Relationships
reports and charts
JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
7 years ago
Work Request table is the parent table of the Poles table and then the Poles table is the parent table of the Audit Logs table

key field of Work Request:WR#
key field of Poles: Pole#
key field of Audit Logs: built in record id

so, I need to make a relationship between Audit Logs and Work Requests? Would I need to make two relationships in order to make the Old WR and the New WR the reference field then make summary fields in each to count the Old WR and the New WR fields within the Audit Logs table?