How to change from user attribute based relationship class to Global 'ID based relationship class and not losing the data .

430
0
02-25-2019 09:53 AM
BPriyaK
New Contributor III

I have a feature classes and table that have relationship class based on a user attribute field as PK-FK.(1-M) simple .This feature class also has Global Id's.

we are moving towards collecting this data now in Collector and as best practice want to move to a relationship class based on Global'Id.

I understand that I have to create a new relationship class as you cannot edit an existing one

but how do I do it without losing the data .

The scenario is 

I have a poles featureclass (spatial)with PoleID (user generated Alphanumerc string) 

with related table of signs (non-spatial) table has PoleID field where the PoleID is Foreign Key in this and its (1 to many) one pole has multiple signs attached to the pole.

Now I want to change the relationship table to have relationship to be on Global'id

how to change this without breaking the data.I'm up for creating a new relationship class and table

I would appreciate insights from anyone who attempted to do this

0 Kudos
0 Replies