A two-way link is a connection between the current field and a field in another – or the same – document. If you change the value of either field, the value in the other field will also change.
A two-way link cannot be used as part of a formula, unlike a one way-link (see Using one-way links in formulas). Apart from this, you build two-links in the same way as one-way links, as follows:
Create a normal one-way link (see One-way links for more details).
Turn the edit source property on:
In a spreadsheet, use the Edit Source button or select the Edit Source property in the Format/Attributes dialog.
In a Write document, double-click on the field, select Attributes from the Field menu and select the Edit Source property.
For example, consider the following database table, called invoices:
In a spreadsheet cell, enter the following formula:
=DBGET("accounts.adb", "invoices", "invtotal", 3)
The result of the formula - 8.5 - is displayed.
Click on the Edit Source button.
You can now enter a new value in the cell, and the database will be updated.