Create a query that contains the Product table as well as the other table(s)
you need.
In the query, choose all the fields you want, including the
ProductDescription field.
Set the RecordSource property of your report to this query.
Since the ProductDescription is in the report's source query, you can now
display it in a text box on your report.