For instance, against ONE inspection record, you have multiple child table for each “section” you stated. So one parent have multiple different child.
Each child table should be allowed to add one row against one parent record.
This should be basic condition.
I would call Child1, Child2 for child tables which store sectional records against one inspection. You need to have some sort of mechanism to avoid user to add the records for the same section against one parent (inspection).
Then on the parent table, you manually create bunch of virtual column to pull all the child record fields, using expression something like
This will pull the Inspector (if the field exist in Child1 table) onto the related record. Using Any expression, but you can use Lookup expression as well. It brings the same result, but you need to make sure the record in Child1 table with the same InspectionID is always SINGLE.
Do the same for other fields and tables.
Then your parent records should have all the related child record as a single row.