Switch to: V9V8V7V6V5

Data Editor - Show Mode

Menu Show Mode have three options how to show linked records in the Related Editor:

  • Show All
  • Show Linked
  • Show Free

Show All

In this mode Related Editor shows all records, as linked so not linked to marked record(s) in the top Table.

Show Mode: All

On the picture we see that in the top table Person record [1] is marked. In the bottom table Phone records [2] and [3] are marked. This means that Person { [1] John Jonson } has two phones {2222} and {3333}.

This mode can be used when you want to link new records to a parent table. You can also use FILTER of records in the bottom Table to find that .

Show Linked

In this mode Related Editor shows only record(s) that are linked to marked record(s) in the top Table.

Show Mode: Linked

On the picture we see in the bottom Table only phones that belong to marked person {John Jonson}.

This mode can be used:

a) when you want to see child-records of marked parent record(s), may be even using Data Editor - Set Operations.

b) to unlink some child record(s). For this you need just click check mark for a child record that you want unlink. After this the record is hidden, because we are in mode Show Linked only.

Show Free

In this mode Related Editor shows records that are not linked to any record of the top table, i.e. these records are free and can be linked to some top-record(s).

Show Mode: Free

On the picture we see free record(s) with Person_Ptr field, which implements a FK-link between top and bottom tables, to be NULL.

NOTE: Lets take the most common case Parent-Child, when top/bottom Tables related as ONE to MANY. In this case this mode shows you “orphan” records, i.e. records that do not have a parent record.