Issue with related tables - FOREIGN KEY constraint

PaulPetersen1 — Mon, 21 Feb 2022 18:19:23 GMT

I'm attempted to insert a new record into a "grandchild table" via URL. I pass in the GUID into the foreign key field that links up with the Parent globalID. Upon submitting the survey, I receive the following error:

Failed to submit. Hide details

- The INSERT statement conflicted with the FOREIGN KEY constraint "REL_FK_XXXX_SCHEMA_XXXX_0". The conflict occurred in database "db_1908", table "user_1908.XXX_SCHEMA_XXXX", column 'GlobalID'. The statement has been terminated.

Everything works fine if I delete the parent-to-grandchild geodatabase relationship. If I have relationships between parent and child and then child and grandchild everything is good. But as soon as I try to have a relationship between parent-child and parent-grandchild, I get the error above.

Stranglely, I can add records to the grandchild directly from the parent just fine in Field Maps, so this seems to be unique to Survey123.

One option is just to adapt a workflow without these multiple relationships, but I'd prefer to keep them if possible.

Re: Issue with related tables - FOREIGN KEY constraint

BethanyCrenshaw1 — Mon, 26 Jun 2023 17:26:02 GMT

Hi PaulPeterson1. I would love to hear if you found a solution. I am having the same issue.

Re: Issue with related tables - FOREIGN KEY constraint

PaulPetersen1 — Mon, 26 Jun 2023 17:35:35 GMT

Unfortunately, no.

Re: Issue with related tables - FOREIGN KEY constraint

SMauri — Thu, 03 Aug 2023 15:39:37 GMT

Same message here.

I have a many-to-many relationship involved in editing session

topic Re: Issue with related tables - FOREIGN KEY constraint in ArcGIS Survey123 Questions

Issue with related tables - FOREIGN KEY constraint

Re: Issue with related tables - FOREIGN KEY constraint

Re: Issue with related tables - FOREIGN KEY constraint

Re: Issue with related tables - FOREIGN KEY constraint