Hello,

I'm quite sure the solution to that is really simple but i can't find which one to use in the documentation.
I'm using JPA annotations and hibernate 3.5

Here is the situation:
2 tables: product_version and product_issue, both tables have a "version" column (which is a String/VARCHAR).

in table product_version, multiple records can exist with the same version but in table product_issue only one combination can exist. I need to link children table to a parent table column which is not a PK and not unique, i also need to be able to retrieve children from the parent using the version.

Any ideas?
thanks