Castelle FAXPRESS PREMIER, Administrator'S Manual

Page: 273 / 639

Admin Guide > Contacts and Phone Books
FaxPress Premier Administrator Guide 257
Creating Table Joins
To access multiple tables from one phonebook view, you must include a new table in your
view and define a join or an association between a column in one table with a column in
the new table. You must define a join for each of the tables from which you want to include
data for your phone book.
can include data from any number of tables, but at least one join has to be defined.
1. Right click on any phone book view and select Properties from the context menu.
The Phone Book View tab will be activated.
2. Select the table you want to join by finding it in the Table scroll down list. In the
above screen the Employees table was added to the Contacts view.
3. Go to the FaxPress field name that you want to map to this Table, and find the
new table field. In our example, the Employee.FirstName and Employee.LastName
were mapped to the appropriate FaxPress fields. As soon as you enter a field from
the new table the Table Joins button will now be activated.
4. Click on the Table Joins button. The Table Joins dialog box will be displayed.