Rudy can you take a look at my relationships when you get the chance?
In this screen shot I have included more tables that relate to the tables in the first screen shot - By taking a quick look can you tell me if are problematic?
I dont really know how else to set the relationship between the tables other than the way they are set up.
Stream site data table contains data collected at a specific point on a stream - at this point riparian data and physical data are recorded
The Reach (a "reach" is defined as a length stream that has homogeneous, or regularly repeating habitat characteristics) data table contains data about a particular segment of a stream - from this segment riparian data and physical data is recorded.
Originally posted by sueviolet
Can you explain your response - "too many one to many" - how is this problematic?
What Rudy said. Coding a single query with this structure could result in virtually infinite results. You need a union of 2 queries. Sorry, I didn't know you were pretty new or I would have explained it better. It's my first visit and I don't know the general experience level of people that come here.