I use Lightroom - set up libraries for each trip, then subdivide using keywords, flags, colours, metadata etc.. etc... very versatile.
Must admit, never thought of linking to keywords from external sources, must be possible though, LR can do just about anything.
Off to have a mess about and...