How to create a lookup column that targets a Doc Lib and uses the 'Name' of the document?

Question

How do you create a lookup column to a Document Library that uses the 'Name' of the document as the lookup value?

I found a blog post that recommends adding another custom field like "FileName" and then using a item reciever to populate the custom field with the value from the Name field but that seems cheesy. Link to the blog in case people are interested: http://blogs.msdn.com/pranab/archive/2008/01/08/sharepoint-2007-moss-wss-issue-with-lookup-column-to-doc-lib-name-field.aspx

I've got a bunch of custom document content types that I dont want to clutter with a work around that should really work anyway.

Answer 1

I created a one step workflow to set the title from the name, fired on modify and created. Seems to work and took seconds to create.