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!