Joining Tables

Add Link Column

In Banana Accounting Plus, you can create links between columns of different tables using the RowId column.

The command Tools > Add/Remove Functionalities > Add Columns for linking tables creates a link column in the current table, with another existing table.

The Description column is automatically added, but if it is not needed, it can be deleted or hidden.

The command only works if the table to be linked contains the "RowId" column.

Choose Table Dialog

A list of tables containing the "RowId" column, which are not linked to any table, is displayed.

Choose the column after which (position) you want the link columns to be added.

Choose Column Dialog

All columns of the table are displayed.

Choose the column after which (position) you want the link columns to be added.

Link between Tables

To create a link between a column of one table and a different one, proceed as follows:

• Open the file where you want to add the table.
• Add the new table "e.g., Projects".
  • In the Id column of the added table (Projects), enter the project code, and in the Description column, enter the project description.
• In the Transactions table, link the columns of the added table (Projects):
  • From the Tools > Add/Remove Functionalities > Add Columns for linking tables menu.
    In the dialog that opens, you can choose the position of the column.
  • Confirm by clicking the OK button.
  • New link columns are added and displayed, starting with the name of the table.
    • ProjectsId where the corresponding code from the RowId column is entered.
    • ProjectsDescription (protected column) where the description corresponding to the entered code is displayed.
  • When the content of the Projects table is changed by entering the Id in the other table, the description text will automatically be retrieved.
• If descriptions in the added table (Projects) are changed, to automatically retrieve the new texts, recalculate or close and reopen the file.

The program automatically links columns that start with the same nameXml of a table and are followed by "Id" or "Description".

• Link columns can be created or added manually by assigning them specific names.
• Do not use these names for columns that should not be linked.