Matrix view allowing checkbox for new record creation/deletion

[Hexxxer]

I have three tables as so:


What I would like to do it take all 'RoleTitle' from RolesList, all 'CourseID' from courselist and show them as a pivot table/matrix with a checkbox that creates or deletes entries from the RoleRequirements table. So, if it exists in the RoleRequirements table then it should appear a checked, unchecking it would delete it from the table.



I am using access 2010 with a SQL server 2005 backend.

Is this even possible?

[June7]

Maybe, probably need VBA to accomplish if possible. Why would you want to? Use filtering to retrieve desired records.

[Hexxxer]

this is not for viewing but for fast editing.

[June7]

Still don't understand - viewing or editing, filter records.