The most astonishing thing about this to me is that despite the fact that underneath the friendly single-'table' view lies a trio of tables as you'd find with any many-to-many relationship, but when you go to manipulate them at the developer level you find... a single table.
I can't belieeeeeeve they've done it like this. I can see the reasoning behind wrapping up three-table joins in a friendly way, but not exposing the guts of it is just crazy.
--
|