Referenced Fields

Referenced fields provide one extra option used to control the select box, called the Pick Root. All columns that display data retrieved through a reference support the <F3> key for a select box, or just start typing and the select box appears automatically. The objects displayed in the select box can be controlled by changing the Pick Root.

A typical example of a referenced field is the name of the cross account on a ledger. To restrict the list of accounts that can be selected, to expenses only for example, change the Pick Root from Account to Account/Expense.

To set/change the Pick Root option:

  1. Activate the referenced field you wish to change the Pick Root option for.

  2. Press <F11> (or issue the command Window>Define Columns) to open the Setup Columns window.

  3. In the Setup Columns window, on the right side, select the Pick Root field.

  4. Press <F3>. This will open a menu tree for you to select from.

  5. Select the new Pick Root by double-clicking on the new folder.

    I.e. to be able to select from a list of all accounts in the database you would select the Accounts folder, or to select from the Accounts Receivable accounts only, select the Accounts Receivable folder, etc.

  6. After you have set the new Pick Root, close the Setup Columns window.

  7. From this point forward, the accounts offered for selection will respect the Pick Root.

    IMPORTANT: A change to a Pick Root will not take effect unless the select box window is closed explicitly by clicking the close button, and then the next use of the select box will recreate it positioned on the new Pick Root.


Copyright (c) 2003-2022 Q.W.Page Associates Inc., All Rights Reserved.