Filters one main table based on another main table, both of which share specific detail information.
If one main table in your publication contains detail information related to another main table in the publication, you can filter one table based on the other. First, select the related main table. Then, if there is not a foreign key constraint, specify the columns in the two tables that relate them.
After the relationship is established, only the rows in the main table that correspond to the filtered rows in the related table will be replicated.
Related Table
Displays the other main tables in the publication. Select the table you want to relate to the current table selected in the filter page.
Column in current table
Lists the columns available in the current main table selected in the filter page. Select a column from the list.
Column in related table
Lists the columns available in the table you selected in the Related table list. Select the column that will relate the tables.
| For information about | See |
| Setting up criteria to filter the data for the publication | Filtering Offline Data for a Publication |
| The operators used in creating a filter | Offline Publication Filtering Reference |
| Making your team solution available offline | Allowing Users to Work Offline |
| Requirements and guidelines for creating offline publications | Planning Offline Capabilities |
| Defining a table hierarchy for your solution database | Setting up a Table Hierarchy |