Take a look at this tiny-tool I've created (work in progress): --deleted for the sake of our future trips--
So far the "hardest" problem seems to be when a thread includes an airline promotion, because that's likely to be a many airports to many airports relationship.