Complex Report Criteria to Report back CN Task to CN Notice
We currently require that our CN Task number matches our CN Notice number. The main reason is for reports that MFG runs against the CN number to get the Resulting Objects in PDF format for a meeting. What I would like to do is type in the CN Notice number and get the Resulting Objects no matter what the CN Task number is that is associated with the CN Notice. It works well if the numbers are the same, but if they get off, then the report doesn't work. When this happens it takes a lot of time and work to get it all corrected, depending on when it was caught. I am hoping that this is a simple join, but does anyone know how to do this?

