One-To-Many Join

Discussion created by craiguwl on May 11, 2012
Latest reply on Aug 24, 2016 by RoadsDept12
Hello all.

I'm looking to join a feature class with an Excel spreadsheet using the Address fields in both entities to base the join on.  However, my Excel spreadsheet has a telephone number field (the feature class does not) and some addresses in it have multiple telephone numbers (multiple entries with the same address but different phone numbers).  The feature class only has one address where as the Excel spreadsheet often times has several.  When I run a basic join, only the first telephone number populates.  I would like to get them all from the Excel spreadsheet.  Is there some sort of one-to-many join that I could run to get the results that I am looking for?