Many to Many Relationships

Question

I am working through a design where there is one geospatial layer (counties), and a project table.  Both contain unique identifiers 1) County = GEOID and 2) Project = Proj_ID.

A county may have multiple projects associated with it, and a project may have multiple counties associated with it.  This would seem ideal for the many to many relationship.  What would be the most optimal approach to creating this relationship?

#optimizing geodatabase #manytomanyrelationships‌

GurunathanGanesarethinam · Accepted Answer

Hello Mark,

Yes, you can create Many to Many relationship class for this.  Follow the ArcGIS help link here to create this relationship class. You can pick Simple relationship class option and then select Many to Many.

http://desktop.arcgis.com/en/arcmap/10.6/extensions/production-mapping-guide/admin-pl-sql-server/creating-and-configuring-the-geodatabase-in-sql-server.htm

Regards,

Guru