I think you are looking for the related value list which will be depend on the input value of Building in the global field (e.g. key_BUILDING). If so you can get it easily by creating a relational value list.
Create a relation from Composite_Score to Building Table which will be mapping like as follows: (key_BUILDING = Building)
Create a new value list which will list only the related departments from selected building. The value list should be create like below screenshot.
Hope this will solve your requirement.
Software Developer, Mindfire Solutions, India
Thanks, I missed the last part with composite score only related. That fixed it.