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?


As mentioned by @brichins in a comment there is ArcGIS documentation entitled "About joining and relating tables" which provides an excellent introduction and tips like:

When using data where a one-to-many or many-to-many relationship exists, you should use a relate or relationship class to establish the relationship between the datasets.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.