Hello everyone,
I have a couple of lists
- Customers
- Products
- Requests
In the requests list I am looking up both customers and products, I also have some calculated fields based on the customer and products lists.
I have migrated the list from SharePoint 2010 to SharePoint 2016 using shargate and I have rebuilt the Nintex form including the lookups to the customer and products lists.
They are, for all intents and purposes, identical including the ID's of the customers and products as I templated them up and re-created them rather than migrating them.
I have updated the lookups incase there are GUID issues and all seems well when creating a new item.
However, when displaying or editing an old pre-existing item, (there's 5000 of them) the customer and product information is not displaying on the drop down.
If I go and find the information and select it again (then save) it displays perfectly fine the next time.
Has anyone ever seen this behaviour before or know a way around it? I don't want to have to manually update 5000 items.