Replace Inspection Table Key Relationships

202
2
Jump to solution
04-11-2024 12:50 PM
MichaelParma
New Contributor III

In the Solution templates, there are related tables for inspections and attachments using the GUID as the primary/foreign key relationship. Does anyone see an issue with recreating these tables using a text field (the assetID) as the relationship? This matches our particular source data.

Thanks,
Mike

0 Kudos
1 Solution

Accepted Solutions
RobertKrisher
Esri Regular Contributor

The constraint is that you can't use object ID based relationships (002568: Branch version relationship classes must not use Object ID for the primary key.—ArcGIS Pro |...). You are welcome to use any user-defined and maintained field. Many customers prefer to use the global ID field because it is a system-generated and maintained unique identifier.

View solution in original post

0 Kudos
2 Replies
MikeMillerGIS
Esri Frequent Contributor
I am traveling, can verify and look it up next week, but I am fairly sure for branch versioned data, a relationship must be global id based.
0 Kudos
RobertKrisher
Esri Regular Contributor

The constraint is that you can't use object ID based relationships (002568: Branch version relationship classes must not use Object ID for the primary key.—ArcGIS Pro |...). You are welcome to use any user-defined and maintained field. Many customers prefer to use the global ID field because it is a system-generated and maintained unique identifier.

0 Kudos