I have a campus environment (multiple buildings located in one site). I am considering adding each building and room number to the CMDB to allow for assets to be related to a location. It would be great to be able to have a series of dynamic drop downs that reference these locations so that location can be managed from a single location and not a custom drop down list that needs heavy management.

Has anyone been able to achieve this? If so, how?