AnsweredAssumed Answered

Report Script Problem - Go to related record

Question asked by MikeTrotter_1 on Jan 7, 2013
Latest reply on Jan 7, 2013 by MikeTrotter_1

Title

Report Script Problem - Go to related record

Post

     I have a system with the following configuration:

     tbl_Cases ----< tbl_Witness-Case_Join >---- tbl_Witnesses

     I have a report layout that uses information about the witness and information from a particular case. All is fine if the witness is involved in only one case. If the same witness is involved in more than one case, only information from the first case the person was involved in is shown on the report.

     I have uploaded a screen grab of the script I am using to generate this report.

     Someone please point me in the right direction.

     Thanks,

     Mike

      

script.jpg

Outcomes