I don't know if there is a better resource for asking crystal reports questions b/c there website didn't help me but if there is a place point me in that direction. Anyhow my wuestion is this. I have a report that displays a record from a requests table (Employee, Course Requested, Approx. Delivery Date) what I need to do is retrieve a value for each of these records from a rates table. The rates table is as follows:

ID CourseID StartDate      EndDate   CostperPerson
-- -------- ---------      -------   -------------
01    04     1/1/2000   06/31/2000       $5800
02    04     7/1/2000   12/31/2000       $6200
03    05     1/1/2000   06/31/2000       $4800
04    05     7/1/2000   12/31/2000       $5200

My problem is how do I, for each request, retrieve the appropriate value from this table in the crystal reports designer.