Re: Struggling making a many to many

2007-03-28 Thread Anthony Roja Buck
, 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 t

Struggling making a many to many

2007-03-27 Thread Roja Buck
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 P

Required Relations?

2007-03-23 Thread Roja Buck
All, I am a little new to databases so I apologise if this query is particularly incompetent. I have created a series of tables all of which are related to one central table with that central table having relations of one to many with the rest of the tables. The problem I have however is that I