Build the link

To build the link record:

1. Click Tailoring > Forms Designer.

2. Type orders in the Form field, and then click Search.

   The orders form opens.

3. Click More or the More Actions icon and then select Link.

   The link record for the orders file opens.

4. Create a link for the code field. Link the (Seller Code) code field on the order file to the (Seller Code) code field on the sales file.
5. Click Save.
6. Click Back to exit the link record and return to Forms Designer.

Note: Use $file in virtual join link line queries and $File in fill and find link line queries.

Related concepts

Virtual joins
Understanding subforms
Forms Designer

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
Use the virtual join
Verify that the sales1 form works

Subform control