Duncan,
No probs, yes, create the columns like you said. and then connect them, and have a hyperlink column to fire the connection.
send me your email to brett@combined-knowledge.com. I will then send you a screen dump as I tested it before replying to you.
Brett
Brett Lonsdale
Partner/Trainer
Combined Knowledge
MCT, MCSD.NET