You create the 7 recordsets and use the Repeat Selection to display the available options for each recordset with checkboxes.
You use the "Manage Relational Table" server behavior to maintain the relationship between the tables... applied once for each of the 7 recordsets and repeated checkboxes.