Existing Table Relationships

This step is displayed when there is more than one way to relate the table you are adding to the query with the other tables in the query. For example, suppose the table that you have already added to your query contains two columns that each identify an account number (e.g., a payable account and an expense account). Now you want to include the account table in your query. When you add the account table, Liberty Reports needs to know which account number (i.e., which account column) to associate with the rows in the account table.

Use one of the predefined relationships

If one of the predefined relationships represents the way in which you want to relate the new table, select this option, select the desired relationship, and then click Finish.

Define my own table relationship

If none of the predefined relationships are desired, select this option and then click Next to define your own relationship for the new table.