No worries all. i have managed to work it out. When i have time i think i
will write a bit of a tutorial for people, like me, who struggle with this
little concept. As it turns out the bane of my problem was that i was simply
not clicking on the window in the ObjRelations properties dialogue, which
then brings up the list of relations to flatten, instead i was trying to use
the "To Many" relation button...
Regards,
Roja
On 28/03/07, Roja Buck <[EMAIL PROTECTED]> wrote:
Hey all,
I am rather sorry to have to ask this as I am sure that it is utterly
obvious to those in the know, however I am really struggling to get my
head
around how to make a many to many relation using the modeller. I have 3
tables:
Address:
ADDRESS_ID
NAME
PhoneNumber:
PHONE_ID
NUMBER
PhoneAddressComposite:
COMPOSITE_ID
PHONE_ID
ADDRESS_ID
Now what I want to do is a simple many to many such that I can go
Address.getNumbers() and I get a list back of all the numbers with that
address's ID from the table PhoneAddressComposite and of course be able to
add additional numbers with ease also. I have struggled to find any step
by
step instructions about how to construct such a simple relationship and
have
only been able to find this page:
http://cayenne.apache.org/doc20/cayennemodeler-flattened-relationships.html
Which I simply cannot understand, maybe because of the assumed knowledge?
I
don't know. I don't suppose anyone has a link to a walkthrough for this
relation? Currently the three tables have no relations what-so-ever
attached
to them as no matter what I seem to try, I fail.
Many thanks in advance,
Roja
