I have a SharePoint 2013 list that is connected to Access 2016 db that consists of over 700 projects. Access is mostly used to display the SharePoint list items in a report view.
Recently the one of the fields in SharePoint list, "Project Customer" was changed from a drop-down list to a People Picker. Now the field is updated as an ID.
The Db is connected to a Table called "UserInfo2" that has all the names connected to the Query.
I changed the field "Project Customer" to a combo box, however the field return is the ID instead of the Name its associated with.
Current Row Source: SELECT [ID], [Name] FROM Userinfo2 ORDER by [Name];
Side note: I have a similar field "Project Engineer" that is also a People Picker configured to point to UserInfo2 and it is working perfectly (done before my arrival). I have matched all within the Property Sheet to this with no luck.
What am I missing?:banghead:
Recently the one of the fields in SharePoint list, "Project Customer" was changed from a drop-down list to a People Picker. Now the field is updated as an ID.
The Db is connected to a Table called "UserInfo2" that has all the names connected to the Query.
I changed the field "Project Customer" to a combo box, however the field return is the ID instead of the Name its associated with.
Current Row Source: SELECT [ID], [Name] FROM Userinfo2 ORDER by [Name];
Side note: I have a similar field "Project Engineer" that is also a People Picker configured to point to UserInfo2 and it is working perfectly (done before my arrival). I have matched all within the Property Sheet to this with no luck.
What am I missing?:banghead: