AnsweredAssumed Answered

Related table editing Survey123

Question asked by emma.lewison on Aug 3, 2020
Latest reply on Aug 4, 2020 by ZSutherby-esristaff

I have been following this How to guide How To: Populate a related table from a Survey123 for ArcGIS feature service for Collector for ArcGIS  but I am getting stuck around step 7 with creating the read only field for the GUID linking. I have set up the field as a text, with the parent feature class' globalID field as the field name have made it read only but I am getting the following error when trying to publish. 

I am able to publish the survey if I skip this step and have the pop up working in collector. However I am then unable to send to the survey as I get the following error 

"This survey was not able to be sent due to the following error: the INSERT statement conflicted with the FOREIGN KEY constraint "REL_FK_QUARRY_INSPECTION_APPRASIAL_0". The conflict occured in database "db_142", table "user_142.QUARRY_INSPECTION_QUARRY" column 'GlobalID' The statement has been terminated"

 

I believe I require the GUID link in order to proceed but I am at a loss at what else I can do. Has anyone got any ideas?

Outcomes