Hibernate version: 2.1

Name and version of the database you are using: MySQL 4.0.16

I have an entity object, a Word with primary key "word_id", and a number of "list" tables, such as "hot_list" or "user_list" which are tables that contain a subset of word_id's.

I've created a "UserList" POJO so I can get a Collection of all the Words reference in the list table, but I'm having a hard time correctly mapping the UserList to the Word (I keep getting null for the word).

At this point I'm looking for a good suggestion on how best to set up the database and do the mapping, such that I can have a table which is a subset of primary keys from another entity table and such that I can remove or add keys to the table.

Jay