Setting up a related table in ArcGIS Online
Step one is to decide what the database needs to contain and what fields will be included.
In this example, I'm setting up a collection app for water main flushing. There are forty-some locations that must be flushed monthly, and they time the flushing and take water samples during the process.
From the PW dept I got the paper form they use to log the flushing and took note of the values they fill in, which will become the fields. The address fields and the comment field can be in the main table because they don't change. In fact, they will rarely add or move a location. The related table needs to have the data that is collected at each flush cycle. These include things like the start and stop time, the number of gallons flushed, and the chlorine readings. Each flush cycle will get new values in these fields, and
