I've explored lookup columns, managed meta column, and external datatypes, and I'm either not understanding them, or I haven't found what I'm looking to do, so I'm hoping I can describe my goal and someone can point me in the best direction.
I want to add a column to an existing document library with information from a separate database. That information is based on the value of the data in an existing folder name within the library.
Specifically what we have is a document library that has many folders in it, one for each of our customers. That folder's name is the customer's ID, which is generally a numeric value. We would like to add a column in that library that displays the user-friendly name of the customer. This column is informational only.
So for each row of that library we would like some mechanism that looks at the customer ID column, and uses that to look up the customer name from an external database table (sql server).
Can someone point me in the best direction to take? I can do coding as well if that's what is required. Thanks for any help.