Hi, some help needed. I got a music-track and participants. For each music-track a participant can take different roles, like artist or composer. So I got a table activity having a music_track_id, a participant_id and a role_id.
Now I want music_track to have a relation mapping to give me all his artists, i.e. all participants for this music-track with the role "artist". How do I do that? Added difficulty, how do I do that without prior knowledge about the kind of desired role? Thanks, Florian ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users