I am working with Sharepoint 2007. I have a list of 130 buildings located in six different cities and three different provinces. I imported this list from an Excel spreadsheet. I also have a document library that contains various files associated with these
buildings. I've added a custom column to the document library that contains a lookup field to the name of each building. I also have two additional custom columns that have the city and province. What I would like to accomplish is to have the city and province
columns automatically be set based on the name of the building selected, such that these values are taken from the same row of this list as the building name.
Hopefully my question makes sense.
Thank you, James
View Complete Post