How do I auto populate a field on one list based on an item entry in another? I have two lists, lets just call the first list DepartmentList and the second list TaskList (both are just custom lists).
DepartmentList will be the list used to pull data from and it contains: Title, Assigned To, Team (Column type for Title and Team is Single line of text, Assigned To is People or Group)
An example value to be entered into this list - IT Support , John Smith, IT
TaskList contains: Task Name, Start Date, End Date, Due Date, Assigned To, Team (Column Type for Title and Team is Single line of text, Assigned To is People or Group, and the others are just Date and Time)
All I need is a simple out of the box solution (if any) to auto populate the Team column when a person is selected for the Assigned To field. Example, If I was to enter John Smith for the Assigned To field, the Team column within TaskList will auto populate with the value of IT.
Also, we'll need to ensure that if the value within the Team column has changed, the values within TaskList is also updated with those changes.
We're using WSS 3.0 if that makes any difference.
Thank you in advance.