JanVanBekkum
Technical User
I have an MS-Access database with links to SharePoint lists. The lookup fields are not all updated when I synchronize after I create records offline . I built a test with the following result:
* I created 4 SharePoint lists A, B, C, D. C has a lookup to A and one to B and D has a lookup to A
* I created an MS-Access database with links to A, B, C,
* I created a record in A (ID=-1), in B (ID=-1) and in C (pointing to A=-1 and B=-1)
* I synchronized
* Now all ID's are correct: A and B got ID=1, C points to A (ID=1) and B (ID=1)
* However, when I add D, make D point to A (ID=-1) and repeat the steps above the pointer in D is not updated, but remains -1. A, B and C are updated correctly.
Is this a Sharepoint/Access limitation or is there a way to resolve it?
Thanks a lot for any help.
* I created 4 SharePoint lists A, B, C, D. C has a lookup to A and one to B and D has a lookup to A
* I created an MS-Access database with links to A, B, C,
* I created a record in A (ID=-1), in B (ID=-1) and in C (pointing to A=-1 and B=-1)
* I synchronized
* Now all ID's are correct: A and B got ID=1, C points to A (ID=1) and B (ID=1)
* However, when I add D, make D point to A (ID=-1) and repeat the steps above the pointer in D is not updated, but remains -1. A, B and C are updated correctly.
Is this a Sharepoint/Access limitation or is there a way to resolve it?
Thanks a lot for any help.
