How do I join many to one?

Discussion created by Tomsriv on Jan 25, 2012
Latest reply on Jan 25, 2012 by csny490
I have a point feature class of street intersections and a table of traffic collisions.  They can be joined by a field of concantonated names i.e. ???Easy St_Main St???. 

I have many collisions at a single intersection, so my join would be many to one and will not work.  What is the proper way of joining so that I can create a point for each of my traffic collisions or join them all to the proper point? 

I tried calculating xy in the intersections layer, joining it to collisions then calculating X and Y in my collision table so I could run the tool ???Make XY event layer???, but it always comes up off in space.  Is their another way?