I'm looking for ideas on how best to approach my problem regarding condition scores of street lights.
Street lights are a point feature class and they have an overall condition rating (1 to 5). They also have 4 major components with overall component ratings (1 to 5). The 4 major components have individual pieces that also have individual ratings (1 to 5) that make up the overall component ratings. Having a few high score on individual pieces can skew the overall rating and lead to us missing one critical piece that may require attention.
Question 1 - Is it possible to auto populate the overall condition field by taking the average of other fields once they have been populated?
We will assign weights to critical pieces/components, so if a lower score has been graded, the overall rating would also go down.
Question 2 - Is it possible to lower the overall condition score (automatically) if an identified critical component scores a low condition grade?
I have done a bit of googling and sub-types and attribute assistants have come up, but i'm not an expert in either. If these can be the solution, can you please guide on how we would set this up?