Updating linked tables
How data is moved When possible, the Move to Share Point Site Wizard moves data to lists that are based on list templates on the Share Point site, such as a Contacts list.If a table can't be matched to a list template, the table becomes a custom list in datasheet view on the Share Point site.To display the Relationships tab, on the Database Tools tab, in the Relationships group, click Relationships.When importing IDs, you must import the lists that currently supply the values to the lookup columns (unless the destination database already has tables that could act as lookup tables).
You must manually create the relationships between the various new and existing tables by using the options on the Relationships tab.
When you import data, Access creates a table and copies the columns and items from the source list (or view) into that table as fields and records.
At the end of the import operation, you can choose to save the details of the import operation as a specification.
Depending on the size of the database, its number of objects, and system performance, the operation can take some time.
If you change your mind during the process, you can click Stop to cancel it.
Search for updating linked tables:
The import operation places the IDs in the corresponding field, but it does not set all of the properties necessary to make the field work like a lookup field.