I'm working on ArcMap, and I have a one to many relation between a building column and the residents in the building.
The attribute table for the building has these columns: id,label,number.
I have an excel sheet containing these columns: number,resident
I'm trying to relate the number from building attribute table and the number in the excel sheet.
How to do that?