I think perhaps the lesson here is to nail down the requirements properly before you start solutioning.

I'm in the middle of some business analysis training at the moment and this has been one of the main takeaways for me. One of the techniques the training suggests to help get to the real requirements is to ask the question why several times over. Interesting that Brent arrived at the same solution.