Report Script Problem - Go to related record
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.