>>ever forget a common word or term you've used a million times? Geez - I'm getting old I guess .... anyway ....
>>
>>what's the proper term for the table (entity) that serves as the "in between relation table" in facilitating a many-to-many relationship between two other tables?
>
>I was taught these were called "associative entities"...they look like normal entities in an ERD, except have a diamond inscribed in them. Damn, it was a fine summer of data modelling where I learned all about that with some fellows from Ernst & Young...learned tons. Hope this helps!
>
>BTW, different modelling programs and methodologies probably call it something different. When I was working in VAX/DBMS before the above project, they were called "junctions".
>
>JoeK
yeah - I remembered 'Junction' - but "associative" is the other oneI was thinking of. - thanks
Ken B. Matson
GCom2 Solutions