Hello everyone.
I have a special problem to solve. I have a relationship like this in my database:
Code:
____________________ _______________
| table one | | table two |
|--------------------| |---------------|
|*id | |*id_version |
|foreign key |1-------------*|id |
|____________________| |_______________|
(* means Primary Key)
I should have a set of table two-datas with the id specified in the field foreign key of table one. The problem is that none of the two fields connectet to each other is a primary key.
The root of this probem is the versionated data in table two. Actually this connection whould be a simple one-to-one but if there is more than one valid result, i get a set of data.
I had a look in the documentation but I couldn't find the mapping for this. If someone has a idea how to solve this, please let me know.
PS: Sorry for my bad English ;)
Login
FAQ
Search