How to: Change or Break Links to Data in Tables
After linking to some data, you might want to use a different data source, or you might want to embed rather than link. To change the data source, you must change the link; and to embed, you must break the link.
To change the link to data in a General field
Open and browse the appropriate table.
Double-click the General field containing the data whose link you want to change.
From the Edit menu, choose Links. The Links dialog box appears.
Note
Choose Automatic to automatically update data any time it changes in the source application, or Manual if you want to manually update data.
In the Links dialog box, choose Change Source.
The Change Source dialog box appears.
Specify the new data source and choose OK.
In the Links dialog box, choose Close to complete the change.
To break a link to data in a General field
Open and browse the appropriate table.
Double-click the General field containing the data whose link you want to break.
From the Edit menu, choose Links.
In the Links dialog box, choose Break Link.
Choose Close.
When the link is broken, the data becomes static.