I was hoping all the experts would have chime in by now and enlightened the new users on how the situation should/could be handled......

I attached a file outlining my solution for the situation. If anyone has a more efficient method, please post it.