Question

Which command is used to set a link between two database files?

Answer 1

hey user!

____
_________

Set Relation command is used to set a link between two database files.

______
^_^

Answer 2

To create a link between two database files, use the Set Relation command

Set Relation:

The command SET RELATION TO creates a relationship between the current table and one or more other tables.

Process:

• Prior to forming relationships, the relationship's target table must be open.
• The target table should be indexed on the <key expression>, with that index serving as the target table's master index.

Syntax

SET RELATION TO [<key> INTO <alias>[, <key INTO <alias>][ADDITIVE]]

SET RELATION ON | OFF | (<expL>)

• The SET RELATION ON or OFF instructions control whether or not relationships are satisfied across the entire system.

• When a record is read from the active table, the key expression for each of the associated tables is evaluated, and the resulting key is searched for in respective master index files.  
• If the key is found, the needed table's related record is read into the associated workarea.
• The workarea's relationships with other workareas are then satisfied.

Conclusion

Creates a link between open tables such that moving the record pointer in the parent table also moves the record pointer in the child table.

#SPJ2