views:

25

answers:

0

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:

  1. I created 3 SharePoint lists A, C, D. C has a lookup to A and D has a lookup to A
  2. I created an MS-Access database with links to A and C
  3. In MS-Access I created a record in A (ID=-1) and in C (pointing to A=-1)
  4. I synchronized
  5. Now all ID's are correct: A got ID=1, C points to A (ID=1)
  6. 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.