Electronic – Choosing a Relay to Operate Solenoid Valve

This isn't too hard to implement. I can see the box and controller getting out of sync, but if the controller hits the zone twice and it doesn't matter what order the two sub-zones come on in, then that seems fine.

You are right in that you need some kind of memory. Since the unit will have no power to it between uses, that memory needs to be non-volatile. A microcontroller with built in EEPROM would do fine. EEPROMs are only good for a finite number of writes, but that's 100s of 1000s at least so no issue there.

When the power to the switch box turns on, all it really does is run the micro. The micro then turns on one of N relays to route the power to one of the sub-zones. It also writes the new state to its EEPROM so that it will power the next sub-zone in sequence next time.

A tiny micro running at slow clock speed can easily handle this. The 5V current will be small so a linear regulator will do well enough and be simple. Get relays that can run directly from the full wave rectified AC so there are no power conversion issues. 24V AC after full wave bridge with filter cap should be around 30-32 Volts. "24V" DC relays would work but get a little warm. Genuine 30V relays may be harder to find, so you could get 24V relays and put a resistor in series with the coil. A reverse catch diode accross the coil and a NPN transistor with base resistor to the micro is all you need per sub-zone output.

Another thing to consider is that the micro needs to see one power up each time the main controller turns on the zone. This should be as simple as putting a little low pass filtering on the micro's reset input so that it doesn't start running until a 100 ms or so after power is applied. By that time glitches and switching transients should be over.

The main controller also needs to leave some off time between powering this zone so that it toggles to the next sub-zone. It will take some time for the voltage to drop before the micro loses power or is shut down by the reset circuit. It could be a second or two depending on what values are chosen.

The more I think about it, the more I'm realizing the trickiest part of this is the reset circuit. You want to make sure the micro runs cleanly once per power up, and that it goes into reset cleanly once on power down and not too long after power down. This is all quite doable, but something that needs to be considered.

An electromechanical relay will work. Hey, they have been used for a looooong time. However, a solid state relay would be my choice for a quick solution. You don't have any contacts to corrode, arc, etc., and degrade. Using an electro-mechanical solution is not optimal... You seldom see an electro-mechanical relay in modern electronics.