We perform stream surveys on the same site on a yearly basis. I included a basic diagram of how our data structure looks. Because we perform the survey on the same sites there is a 1:M relationship between the FC and each table (sitecode is the unique identifier). The main reason for this structure is to support our mobile data collection effort. We are using the Collector app; the data is hosted on our ArcGIS Server and added to AGOL.
I have tried to create a basic spatial view, but the only way I was to accomplish this was using a table that did not have a relationship class to the FC, I have done some reading online but have been getting a little overwhelmed!
So, I would like to create a spatial view that shows our sample location with attributes from all four tables; this was a request from the user that will be performing queries and generating reports from this data.
If it is not possible to create a spatial view, would it be possible to create a view of all four non-spatial tables then create a 1:M to the FC??
I am using ArcGIS 10.2.2 and all tables are versioned in an sde gbd. If any other informaiton is pertinet to identifying a solution please let me know!