I have an MS-Access 2007 database with links to SharePoint 2007 lists, I run XP professional. 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 3 SharePoint lists A, C, D. C has a lookup to A and D has a lookup to A
- I created an MS-Access database with links to A and C
- In MS-Access I created a record in A (ID=-1) and in C (pointing to A=-1)
- I synchronized
- Now all ID's are correct: A got ID=1, C points to A (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 and C are updated correctly
See this illustration to make it clearer.