Subreport for access. Help!

[Ridzuan]

Hi all,

I created 2 tables.

EmployeeTable


--------------
EmployeeID(PrimaryKey)
Employee

http://imageshack.us/photo/my-images...mployeest.png/

CoursesTable
--------------
CoursesID(PrimaryKey)
CoursesName
Status[LookupWizard(Completed,Failed)]
EmployeeID(ForeignKey)

http://imageshack.us/photo/my-images/853/coursest.png/

Then I created a form from EmployeeTable displaying the employee name at the top. I then created a subreport which i want it to display the list of coursename. However when i created the subreport, no coursename was listed in the subreport.

http://imageshack.us/photo/my-images/705/formd.png/

Please help.

[hertfordkc]

Or wipe them out after you linked them?