need help with this query

K

keyur

I have 3 tables:

1 Courses: columns- Course ID, Course Name, and then 1
column for each workgroup(checkbox). In each col. I have
checked off the coursenames that applies to the workgroup.

2 Work Groups: columns - Workgroup

3 Employee List: col - Employee #, FirstName, LastName,
Workgroup


This is what i want to do

I want to add subdatasheet in the Employee List that will
show all the courses for that employee (i.e depending on
which workgroup it belongs to)

similarly, i want to add subdatasheet to the WorkGroups
showing the list of employees that belongs to the
workgroup.

Thanks for any help

Keyur
 
Top