topic Re: Relationship class fields in Python Questions

Relationship class fields

BillChappell — Mon, 31 Aug 2020 18:42:51 GMT

I've create relationship classes but they want to see specific fields as the attribute index. .i.e. See yellow highlighted text. In my case I have points and have about 10 Relationship class tables. They all seem to work properly, but for each attribute table the field value it's showing under "Attributes from xxx" is coming from different fields. How do I specify which field to use? I'm using a script to create these and the tables are related all on the same field names. Is there a way to set the fields it uses for this?

I'm using python to create these, here is my code:

tables = arcpy.ListTables()
for i in tables:
if (i != 'Structure'):
print(i)

tab = i
relClass = i+"_rc"
forLabel = "Attributes from Table"
backLabel = "Attributes from " + i
foreignKey = "equipment_number"
primaryKey = "PARENT_EQUIPMENT_NUMBER"

arcpy.CreateRelationshipClass_management(tab,
"StructurePts",
relClass,
"SIMPLE",
forLabel,
backLabel,
"NONE",
"ONE_TO_MANY",
"NONE",
primaryKey,
foreignKey)

Re: Relationship class fields

BillChappell — Tue, 22 Jun 2021 08:34:34 GMT

Looks like you can't do it yet.

primary display field on table with relationship class

https://community.esri.com/ideas/15324

Re: Relationship class fields

BillChappell — Mon, 31 Aug 2020 19:11:50 GMT

My mistake, you need to add all the tables into ArcMap, Right-click Display, pick the Field, for each table. So it's stored in the MXD somewhere, can you hit this with Python?

Re: Relationship class fields

JoeBorgione — Mon, 31 Aug 2020 19:43:32 GMT

There are a couple of things that are confusing to me: first, a relationship class is database object so you would get to it that way, not through an MXD. Second, it looks like the 'Attributes From Anchor' are named with numbers at the beginning, so I'm very curious how you've been able to get away with that. (see FAQ: What characters should not be used in ArcGIS for field names and table names? )

Re: Relationship class fields

BillChappell — Mon, 31 Aug 2020 20:04:39 GMT

Hope this helps. The map uses the tables in the MXD, the relationship class manages the relationship between the feature and the other tables. So in a Map doc (mxd) you can set the primary display field to use when you identify. I noticed in the relationship it was showing the related records but that number you see was an attribute value for the field it was using. If I went to the table, set it to display the primary display field, it showed the value for my field, which made more sense to me. Now if I clicked on this value, in the bottom part of the identify dialog, it showed the other fields and attribute values.

Re: Relationship class fields

JoeBorgione — Tue, 22 Jun 2021 08:34:37 GMT

So in a Map doc (mxd) you can set the primary display field to use when you identify.

Okay, gotcha. I'm not using mxd's anymore so I'm no help there. It looks like someone had a similar need some time ago: https://community.esri.com/ideas/4647