Goal: I want to show the police calls coming from a parcel on ArcMap. So if you click on the parcel, it will show all the calls for the year. I want to join the address attribute from the parcel data to the police file's call address (which was created by concatenating street number and address to match the parcel layer)
Issue: many addresses have more than one call from different dates; one property even had 100 calls. The parcel layer has only one polygon for each address, so I can't show multiple records for the join.
How do I join so that all 100 calls would be joined to that parcel?