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.