SharePoint Dev Center >
> 
> 
Adding fields from SharePoint 2010 lists to the Access/SharePoint 2010 Contacts Web Application

Odpovědět Adding fields from SharePoint 2010 lists to the Access/SharePoint 2010 Contacts Web Application

  • Tuesday, April 17, 2012 6:00 PM
     
     
    Sign In to Vote
    0

    I am trying to add additional fields for contacts within the Contacts Web Database. I have linked my SharePoint lists as External Data > SharePoint List > Linked Table. The selected lists show up in Access under tables.

    The problem is when I go into the Contacts table and try to add a new lookup field (Lookup & Relationship) and select "I want the lookup field to get the values from another table" I do not see the SharePoint list "tables."

     

All Replies

  • Wednesday, April 18, 2012 7:50 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi DRGDC,

    We can only add lookup field from a list in current (contacts web application) site to the Contacts list. So please

    1. Export your list to Excel.
    2. Go to Contacts web application site, Create a new list by importing the Excel file to a list.
    3. Open the Contacts web database in Access > Export the list we created in step2.
    4. Add Lookup filed again, this time you will find the list in available table list.

    Best regards,
    Emir

    Emir Liu

    TechNet Community Support