Re: Many to Many with an ordered join table

2009-05-08 Thread Chuck Hill
Hi Charles, Welcome! On May 7, 2009, at 5:20 PM, Charles Young wrote: Hi I'm sure I have a commonly seen issue: I have a many to many relationship between tables SOURCE and DEST. This is implemented by a third table GLUE which contains the PKs of SOURCE and DEST as well as an integer

Re: Many to Many with an ordered join table

2009-05-08 Thread David Avendasora
On May 8, 2009, at 1:30 PM, Chuck Hill wrote: Hi Charles, Welcome! On May 7, 2009, at 5:20 PM, Charles Young wrote: Hi I'm sure I have a commonly seen issue: I have a many to many relationship between tables SOURCE and DEST. This is implemented by a third table GLUE which contains the

Many to Many with an ordered join table

2009-05-07 Thread Charles Young
Hi I'm sure I have a commonly seen issue: I have a many to many relationship between tables SOURCE and DEST. This is implemented by a third table GLUE which contains the PKs of SOURCE and DEST as well as an integer property (order) that describes the order of DESTs with respect to SOURCE.