Many to Many Relationships

[Anonymous User]

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 solution]

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/cre...

Regards,

Guru