The status bar of the table browser window contains indication of enabling or disabling display of identical records – “Duplication enabled” or “Duplication disabled”.
Records are considered identical (duplicated) if all their displayed fields contain identical values.
Please pay attention that when comparing records only displayed (not hidden) fields are taken into account.
To disable displaying of identical records, that is, disable duplicating, it is necessary to clear the box Enabled in the pane Duplication of records on page “Sorting” (figure 24-2) of the property sheet “Properties of query”.
It should be noted that removing duplicated records is performed by sorting a table by all displayed fields. That is why it may cause the following results:
for tables with a big number of records the present operation can take considerable time;
if the displaying order is not specified, after removing duplicated records the table will be sorted by the condition which includes all visible fields for each of which ascending order is specified, priority in sorting condition is determined by a relative position of fields in the table browser window.
It should be noted that if duplication is disabled, the query becomes non-editable, that is, adding, removing and editing table records is disabled.
Example. Let's assume that it is necessary to make a list of city streets according to the table “List of Building Certificates”. It can be done very easily by hiding all table fields except for the field “Street”. However, the name of one and the same street can be repeated several times since several buildings may be located in the same street. After disabling duplication a list of streets without repetitions can be received.
 |  |
