I'm attempting to link an embedded subreport to my main report. the table which the subreport comes from is connected via a relation table to the mortgage table which is my main report. I'm attempting to use a parameter on the subreport of mortgage.loannumber which is connected to the relation table and then in the relation table, the nameaddrcd is connected to the nameaddr.nameaddrcr table. Hoepfully I explained that well. I keep getting errors when i run it, so I'm trying to create a third dataset and my code is.
FROM mortgage inner join
relation ON mortgage.loannumber = relation.loannumber AND nameaddr.nameaddrcd = relation.nameaddrcd
Hopefully this is possible and i'm somewhat going in the right direction.
thanks and have a good one.