Hi,
My question relates to a list I have created that shows our team who our internal stakeholders are. We select thier name from a person/group column and then add in using Lookup columns, which division and department they are from.
So I don't have to worry about updating the look up lists whenever a team changes it's name or if a person leaves to go to another team, I thought I would add 2 more person/group columns in place of the lookup columns.
So now, a user has to enter the stakeholders name 3 times in the 3 person/group columns and they are set to display the Name (Person Column 1), Division (Person2) and Department (Person3).
Now the problem; I'm looking for a way in SharePoint Designer (SPD) so when the user is on the new item form, they only need to enter the stakeholders name (Person Column) once.
Then, using SPD, I would like to adjust the display list so the Stakeholders information is showing in the three Person columns. The 2 news columns show the stakeholders division and department. The other 2 columns will have automatically copied the source date from the original name column and are now displaying (the same source data) as division and department.
Is this possible?? I appreciate any help you can offer.