Subtenante,

Thanks for the thoughts. I have since determined that a member can have
more than one title so I will be adding an additional table.

Regards



subtenante wrote:

> On Fri, 11 May 2007 06:07:59 +0200, "J.O. Aho" <user@example.net>
> wrote:
>
>
>>user wrote:
>>
>>>Can one add some extra data into the link table on a many to many join.
>>
>>Sure you could do that, if you want.
>
>
> I would add that from a design point of view, you have very often many
> to many tables that have this function (among others) even if they
> don't get the name directly. If you want to add some columns in your
> M2M table, maybe it's worth considering that it is more than a simple
> M2M table, and give it a proper name regarding what it contains.
>
> In your case, you could name it "title", for example. It is then,
> conceptually, more than a simple M2M table, but represents a whole
> concept within your model.
>
> Sometimes, you need only a M2M, with the 2 primary keys. it's then ok
> to call il M2MFooBar. But if it does something more, try to get a name
> for it, it might help you tidying your idea of what your DB
> represents.