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
user <some
@someplace.org> wrote in
news:8BR0i.7049$yM2.666@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
-----------------------------------------------Reply-----------------------------------------------
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 <some
@someplace.org> wrote in
news:8BR0i.7049$yM2.666@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
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
