Develop > Tailoring > Links > Virtual joins > Example: Creating a virtual join > Create the sales record list

Create the sales record list

Applies to User Roles:

System Administrator

To create the sales record list:

  1. Click Tailoring > Forms Designer.
  2. In the Form field, type sales.qbe, and then click New.
  3. Click No at the Forms Wizard prompt.
  4. Draw a table on the design space.
  5. Type Code and Location in the Columns field of the Table properties window. These are the two database dictionary keys for the sales file.
  6. Type code in the Code column input field.
  7. Type location in the Location column input field.
  8. Click OK to finish.

Related concepts

Virtual joins
Understanding subforms
Forms Designer

Related tasks

Example: Creating a virtual join
Build the sales form
Create the sales file
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

Related references

Subform control