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."
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.