Dropdown Column Selection in Document List Links to a Document (SharePoint 2010)

Question

I currently have a document library where I (additionally) have a 'Choice (menu to choose from) column with a bunch of select-able items. Ideally, I'd like to have the user select an item when they create their new document, and that item chosen links to a document that they can click on for more information (the selected item would be something like... "Fall Hazards", and would link to a document or reference about fall hazards that would open up in the respected Word or PDF reader).

So in effect, it'd be like a dropdown list of links, but I know the 'Choice' column type doesn't allow link references by default (that I know of), and the 'Hyperlink' column type only allows for 1 per row. Is there a way to make this happen? I tried using the 'Lookup' column in hopes of getting the "name" field that is created for the file-name a possible choice that contained the link. If this is something I can do through a workflow or coding, could someone give me an overview of what I'd need to do?

Thank you for your time.

Answer 1

If you use a separate list to maintain your text and related hyperlinks, you can use additional columns in lookup field. For example, create a custom list with a custom column url. The title field will be your main lookup field (fire hazards) but url will be additional field which links to a document in a library.

Check this screen shot