Use the virtual join

Applies to User roles: System Administrator

Once you save the record, you see the virtual join information whenever you select, add, or update the record.

To create a new orders record using the orders form.

  1. Click Tailoring > Database Manager.
  2. Type orders in the Form field, and then click Search.

    The "orders" form opens.

  3. Type the name of a customer in the Customer Name field.
  4. Type a contact for that customer in the Contact field.
  5. Type a number for the Phone field.
  6. Type any number for the Order Amount value.
  7. In the Seller Code field, select a seller code from the record list of seller codes.
  8. Click Add to save the new orders record.

The new orders record appears with the sales file data virtually joined in the subform at the bottom.

The Seller name and commission fields are not stored with the record in the order file. They are only referenced and are noneditable. To make changes or updates to the seller data, use the sales form.

Note: If you delete this record, Seller name and commission do not delete because they are stored in the sales file.

Related concepts

Virtual joins
Understanding subforms

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