Creating relationships using more than one field per table

User 9aa4619393

18-10-2011 10:47:58

Hi,


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?


Thanks


Anna

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.


Tim