Re: many to many join

From: Digeratus 2006 <digeratus2006_at_nospam.hotmaildotcom>
Date: 11 May 2007 04:02:31 GMT
Message-ID: <Xns992DCB02E25digeratus2006@63.218.45.20>

user <someone_at_someplace.org> wrote in news:8BR0i.7049$yM2.666_at_bgtnsc04- news.ops.worldnet.att.net:

> Can one add some extra data into the link table on a many to many join.
> Currently it only contains two id's from each table as primary key.
>
> Have a group table and a member table and a link table. Want to add a
> 'title' column but the only current table it could go in would be the
> link table. Ok, or no?
>
> TIA
>

OK
The mamber's title is his/her function in that group. Unless a person can have more than one title in the group. For instance in our chorus, the "Director" is also the "Leader of the Tenor Section"

HTH
Andy Received on Thu May 10 2007 - 23:02:31 CDT