Hi Philip,
Thank you so much for your time and expertise.
I did initially set up this way but I do not want the user to create any features, but select from an existing feature and have the data pass to the related table.
I found this article:and mid page this paragraph:
Settings worksheet:https://community.esri.com/t5/arcgis-survey123-blog/working-with-existing-feature-services-in-arcgis...
The settings worksheet of the initial XLSForm contains two key pieces of information:
- submission_url: This column defines the url of the feature layer item in your ArcGIS Organization on which responses to your survey will be stored. This is the exact url of the feature layer you chose in the Create New Survey dialog as the seed of your survey. Note that this is the url to the feature layer item, rather than the url of the feature service itself.
- form_id: This column defines the name of the layer in your feature service that your survey will hit. If empty, your initial XLSForm design will always point to the first layer found in your feature service.
While you often may not want to change the submission_url, there is one use case where changing the form_id is very handy. Think for example, that you want to create a survey on top of a related standalone table. For clarity, lets think of a feature service with parcels (polygons) and their related assessments. You may not want to build a survey to edit the parcels, but you may want to create one to create the assessments. Typically, when you get the initial XLSForm design, you will have questions in your survey for all the fields in the parcels layer and then a repeat group, with all questions in the related assessment table. This is only because in a feature service, typically the layer with geometries (parcels in our case) goes first, and then the related tables. To create your parcel assessment survey you will delete all questions corresponding to the parcels layer from your survey and then take the name of your assessments repeat and put it into the form_id setting. Finally you will delete the begin_repeat and end_repeat rows in your survey.
To ensure that assessment data is properly attached to the corresponding parcel, it is important that in your survey you preserve a question to enter the unique identifier of the parcel. You will need to know what field in the child assessment table is used for the geodatabase relationship.
