Structure many to many for relationship

forestknutsen1 — Fri, 15 Jan 2021 00:48:36 GMT

I am not sure where to post this question. So, please feel free to suggest a move if necessary.

The Environment: We are on ArcMap 10.6.1 with a versioned Oracle SDE

The problem: I have a polyline feature class that we have been asked to relate to a stand-alone invoice table. Each table has a feeder ID field with many records for each feeder id. So, each feature should be joined to all others with the same feeder ID. Also, the stand-alone table is read-only, as it is updated nightly by a batch job.

I tried a many to many relationships with the Feeder IDs as keys so each row in the relationship table looks something like this:

RID	POLYLINE_FEEDERID	INVOICE_FEEDERID
1	SS1	SS1
2	SS2	SS2

This works fine until one deletes one of the polylines. Let's say you delete one with a feeder ID of SS2. Then the system deletes the row RDI = 2, breaking the relationship between all other records with a feeder of SS2!

It would seem that my only option would be to relate each feature within a feeder ID to each invoice using global ID and invoice IDs as the keys. That way each time you delete a feature the system would only break the relationship for the deleted feature. Is there a better way to do this? It feels like this should be not quite this complex.

Thansk!

Re: Structure many to many for relationship

Anonymous User — Wed, 20 Jan 2021 05:19:03 GMT

Hi! It would be worthwhile reading this doc and seeing if 'relate' might be more relevant to what youre after.

Heres some esri documentation on the differences, it may or may not be helpful for your case

https://pro.arcgis.com/en/pro-app/latest/help/data/tables/joins-and-relates.htm

Good luck 🙂

topic Structure many to many for relationship in Geodatabase Questions

Structure many to many for relationship

Re: Structure many to many for relationship