Develop > Tailoring > Links > Virtual joins

Virtual joins

Virtual joins allow you to display data fields from several different database files on a single form. Virtual joins do not allow data entry into the joined fields; they only display information from other files into a format for reference purposes.

Virtual joins can be used on any format. They are established when data from a record is displayed without the need to use the Find and Fill functions of the link utility.

You create a virtual join by adding a subform to any form, and displaying the desired data there.

Related concepts

Understanding subforms

Related tasks

Example: Creating a virtual join
Build the sales form
Create the sales file
Create the sales record list
Add data to the sales file
Create the sales1 subform
Create the orders form
Build the virtual join into the form
Build the link
Use the virtual join
Verify that the sales1 form works