Joining Data with duplicate records....

Discussion created by bkeller1986 on Aug 5, 2011
Latest reply on Aug 5, 2011 by dhoneycutt-esristaff
Im attempting to join a list of addresses from our local police department with an address point layer. The excel spreadsheet given to me, has an address field, and a description field. There are several locations where multiple incidents have occurred, my problem occurs when I try to join the two tables based on the addresses. Arcmap will only join the first matching record, then drop any subsequent duplicates. Is there another way to go about doing this so I can represent those locations that have had multiple incidents?


ArcEditor 10