Thanks Lowell, I'll start working on using computed columns.

If anyone else pictures an even better way when reading this post, please share your ideas 🙂