Relationship help

I have four forms:

Courses Offered

Employee

Req Training

Courses Taken

Course

Name

Name (Lookup)

Course(Lookup)

Expiry Date

I am having trouble making the relationships. The forms with the look-ups are working great.

I would like a report that looks like:

Name

Required Course

Courses Taken

John Smith

Course (required Training)

Course Expiry Date (Blank if not taken)

Any help is appreciated.

Thanks,

Wouter