Forum OpenACS Q&A: Response to What is the best way to implement many-to-many relationships between ACS Objects?

You simply use a mapping table.  Period.  You can find examples in
any book on relational databases.