Tips for working with Master-Detail Browser

Last modified: April 26, 2022

This topic provides tips for working with Master-Detail Browser and describes the issues you may encounter when using this functionality.

Working with tables containing large amounts of data

If you have a large table and want to view only some data from the table based on certain criteria, you can write a WHERE condition in the Design view of the master-detail document. In addition, you can specify how many rows should be displayed in the result set. For more information about how to perform these operations, see the To set a limit for the rows in the result set and specify a filtering condition section in How to work with Master-Detail Browser document.

Issues that may occur when viewing data of related tables

• If a cycle in the table is found, the following error message may arise: ‘Cannot retrieve master-detail data. The cycle in table table_name was found.’ That means that you cannot view table data.
• If there are tables that do not have relationships with any table in the master-detail document, data of such tables won’t be displayed in the Data view.
• The one-to-many relationship can be processed in Master-Detail Browser. However, the tables must reside in the same scheme. Otherwise, they will not be displayed in the Data view.