My office uses SharePoint 2007 and I am trying to design a workflow that will populate information from another "List" into my "Current List." For example, I work for a school district and we have over 660 schools. In my "Current List" I have a column named "School." This column has a look-up feature which is linked to other "List." So, when I select the school's name it will automatically populate that information into the "Current List." Now, in my current list I have other columns that further identify the school; "Address" and "Principals Name." I want to be able to create a workflow in SharePoint designer that will automatically populate the corresponding school's information in those columns. Is this possible. I am not tech savy at all….