Re: many to many join

From: user <someone_at_someplace.org>
Date: Fri, 11 May 2007 15:06:44 GMT
Message-ID: <8E%0i.8381$yM2.1453@bgtnsc04-news.ops.worldnet.att.net>

A point I just thought about. In fact it is true that members can have more the one title or position.

So, my next step is to create a title table. A point for perhaps more upfront analysis.

Digeratus 2006 wrote:

> 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 Fri May 11 2007 - 10:06:44 CDT