topic Re: Unsupported relationship type when publishing in ArcGIS Survey123 Questions

Unsupported relationship type when publishing

KirkJones — Wed, 07 Apr 2021 18:45:09 GMT

I am trying to create a survey in connect version 3.11.123 using an existing feature layer. There are two related tables and both the primary and foreign keys are the globalid. When I go to publish I get an error stating "survey123 unsupported relationship type esriFieldTypeGlobalID in key field globalid for table globalid". I haven't really found anything in my searching for solutions.

Re: Unsupported relationship type when publishing

DougBrowning — Wed, 07 Apr 2021 18:49:59 GMT

The related table calls the field parentglobalid. You can have other relationships but this one has to be there i think.

Hope that helps

Re: Unsupported relationship type when publishing

KirkJones — Wed, 07 Apr 2021 18:56:18 GMT

I apologize for my lack of understanding. So does that mean I need to add the parentglobalid field to my table?

Re: Unsupported relationship type when publishing

DougBrowning — Wed, 07 Apr 2021 19:03:33 GMT

yes add the field parentglobalid string 255 to the child table.

Re: Unsupported relationship type when publishing

KirkJones — Wed, 07 Apr 2021 19:16:39 GMT

Thank you

Re: Unsupported relationship type when publishing

IanMackenzie — Thu, 05 Aug 2021 15:54:30 GMT

I suspect the issue may be using the same name for primary and foreign key (primary key in/of the parent table and foreign key of the parent in the child table). These names need to be different, e.g. "GlobalID" as the primary key of /in the parent table, "parentglobalid" as the foreign key of the parent table in the child table (see example screenshot below). I didn't try changing the names from what was previously suggested so its also possible this is just an ESRI naming convention that needs to be adhered to. I set both keys as type GUID.

Re: Unsupported relationship type when publishing

ShariForbes — Wed, 01 Dec 2021 16:28:43 GMT

This solution worked; however, the "parentglobalid" has to be a GUID field, not a text field, otherwise you cannot make a relationship class with two different types of fields.

Re: Unsupported relationship type when publishing

DougBrowning — Wed, 01 Dec 2021 18:04:04 GMT

They do not need to be different - I use the same field name on both sides of the relationship class all the time.

It is 123 that has to have those set field names since it is coded in.

Re: Unsupported relationship type when publishing

Slamon — Tue, 29 Oct 2024 15:41:42 GMT

This issue persists in v3.13. If I build a workbench from scratch that includes repeats, the relationship class that is created will use GlobalID from both tables. So why doesn't this work when using a feature service?

the attachment shows the participating tables and how they are related to each other at this stage.

Re: Unsupported relationship type when publishing

MaazaMekuria — Thu, 12 Jun 2025 23:54:42 GMT

@Slamon , if you check out the child layer or table of the relationship (repeat table/layer) fields, you will notice that there is a "parentglobalid" field on each of the child tables that is a GUID field type that is automatically populated when a record is created in the Parent Table. Survey123 needs that to related the records between tables. The GlobalID fields for the two parent-child tables are only related via the parentGlobalID field in the child table.