I'm creating a form that will allow field workers to record individual tree heights within a number of plots, within a number of areas.
1. The field worker will visit an area and record general information (date, objectives, weather etc.).
2. They then visit a number plots within the area and record more plot-specific info (plot ID, slope, aspect etc.)
3. In each plot the field worker records individual trees heights
Currently the only way I know how to implement this is via table joins leveraged on parent Global IDs populating the GUID field in the child.
Area Survey (parent)
Plot Survey (Area Survey Global ID -> GUID)
Tree Survey (Plot Survey Global ID -> GUID)
The end goal is to have several 'Area Surveys' containing 50+ plots that each contain basic information on tree heights.
I'm looking for some general advice to make sure I'm on the right track. Alternatively, if there is a better/more efficient way of doing this then I would like to learn about it.
Thanks in advance