The error message, "The INSERT statement has conflicted with the FOREIGN KEY constraint" is returned when submitting a survey that has a Global ID value in the globally unique identifier (GUID) field that does not participate in a relationship.
Test the workflow using Survey123 Connect for ArcGIS version 3.1.126 and Survey123 for ArcGIS field app version 3.1.158 and unable to reproduce the issue.