Creating relationships using more than one field per table

User 9aa4619393

18-10-2011 10:47:58


how can one create relationships between entities involving more than one field per table? What I mean is something that in SQL would look like:

a.structureid = b.structureid

and a.summary_key = b.summary_key

is creating two separate
relationships between the same two entities ok , or is there a better way to do it?



ChemAxon fa971619eb

18-10-2011 10:56:51

Relationships that uses multiple columns are not currently supported in IJC. We plan to add support for this in the future.

Currently your best option is to derive a single column that combines the values into a single column, and to use that.