Grid type report

HI, Steve -

You are almost there.   Try this

• Create a new table called Employee Classes
• Build relationship one Employee to many Employee Classes.  If employee name is not the key field. create a look-up field in the Employee Classes tale.
• Build another relationship of one Class to many Employee Classes.  Create a look-up field for class description. (You can also add one for session date.)
• Add 2 fields to the Employee Class table like "Reserved" and "Attended."  Reserved can be a date field or checkbox field.  Attended should be a date field or a check box.
• You can now run a report in the Employee Class table to show class description, employee name and date attended.
• Migrate the data from the reservations table into the Employee Classes table.  This might be tricky.  Contact me via the website at CloudBase Services if you need help.
• Delete the reservations table once the data has been moved.

You can now do many other things: let people sign-up online, create online or paper attendance sheets, assign people to take courses based on roles, etc.

Best,

Debbie