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?