Two-way links

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:

  1. Create a normal one-way link (see One-way links for more details).

  2. Turn the edit source property on:

For example, consider the following database table, called invoices:

image\intgrt3.gif

  1. In a spreadsheet cell, enter the following formula:

     =DBGET("accounts.adb", "invoices", "invtotal", 3)

  2. The result of the formula - 8.5 - is displayed.

  3. Click on the Edit Source button.

  4. You can now enter a new value in the cell, and the database will be updated.