I have been tasked with replacing an old access based form with a survey 123 form. The access form contains 4 sections that each write to a different table in the database. Is it possible to create "sections" in a single survey 123 form that write to different tables/feature layers?
Yes, it is possible to create sections that write to different tables. In Survey123, these are 'repeat' questions - while designed for multiple entries in the same form, they can be restricted to one entry using repeat_count. See Repeats—Survey123 for ArcGIS | ArcGIS for more information.
I may be confused on how repeats work but it doesn't seem like they would allow me to write from a single survey to multiple feature services... In my case, I don't need to repeat questions, I am simply looking to incorporate 4 different inspections into a single survey 123 form. Each section (inspection) of the survey will populate a different table in our database.
The tables need to be accessible from the same feature service and also have a relationship class that connect them (so that the different sections can be linked).
You can use repeats within your survey to create related tables for each section, and then break out each repeat into its own section survey. Use the service URL and form ID within those break-out surveys to point captured data back to the hosted feature service and its corresponding related table.