Cycles 14-16 will remember the challenge of presenting the currently assigned courses and cbo’s for the DePaul application. No other page in the entire system went through more rewrites.
Context:
The application is designed to facilitate the matching process between courses (which have students), and cbo’s (which need volunteers). The assignments table creates a many-to-many relationship between courses and cbo’s, where a single course has several cbo’s that will work with it, and a single cbo can work with many courses over time. The implementation was done using node referenced cck fields. You can see the datamodel here:
http://www.gliffy.com/pubdoc/1408817/M.jpg
Problem: