>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