SharePoint: Document Library as a Lookup field source

Went to create a Lookup field in a list to point at a document in a document library. Sounds pretty straight forward? Unfortunately not.

Document librarys use Name is the main column. It still contains the Title column but this column isn't required. When people upload files they will more than likely leave Title blank.

Move along to the Lookup field creation. You only have the option to pick:
Title
ID
Created
Modified
Copy Source
Version

Do you see the issue? The only good field to pick here is the Title field. But if all the Titles are blank you won't have anything to choose from?

At this stage the only workaround I can think of is to create a workflow which fills in blank Title fields on creation and on change. Messy but will fix this particular issue.

Good luck.

SharePoint 2010: Master page and sub team sites

Had a weird issue today.

Created a masterpage and placed it in:
http://servername/_catalogs/masterpage/Forms/AllItems.aspx

Which works just fine for publishing sites but team sites didn't play ball.

I've read a few posts which suggested that you have to activate the publishing feature (both on the site collection level and the site level). Which didn't work for me.

Issue:
Team sites didn't pick up the Master page even after setting:
http://servername/_layouts/ChangeSiteMasterPage.aspx
Site Master Page > Specify a master page to be used by this site and all sites that inherit from it
Selecting my custom master page.
Check: Reset all subsites to inherit this site master page setting

Solution:
Set the "System Master Page".

For some reason team sites use the System Master Page. Don't ask me why. And I don't have time to investigate right now. But there's the solution.

PS. Happy New Year!