Problems with that are:
1) The table says it can't be linked when the report is run.
My fix for this was a formula as follows:
if {viewRequests.DeliveryDate} >= {viewRates.StartDate} and
{viewRequests.DeliveryDate} < {viewRates.StopDate} and
{viewRates.CourseID}={viewCourses.ID}
then
{viewRates.Price}
2) It now shows the right prices for the correct course but it shows the first rate for that course in the first request (regardless of whether it should) and the second rate for that course in the second request and so on, and so forth until it runs out where it just displays a blank.