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...
I did like you suggested, and it works partly. It only summarizes the total number of logs based on the poles in the current WR, so if 2 out of 5 poles in a WR have logs and are listed in the WR as being added in after the initial WR date it'll summarize those, but it doesn't summarize any poles that were taken out of the WR and either put in another WR or not given a replacement WR. Below is an example of when there were only poles taken out of a WR.
Will I need to use the "Old WR" field in order to make this work. Currently, that field is just a simple text field that gets it data from a quickbase action that takes the old WR data to overwrite it.
