Creating a matrix form

A matrix shows information from multiple tables at the same time. This recipe will show you how to create a matrix that shows the amount a customer has spent on specific items.

How to do it...

1. Add a global function CalculateData that returns a text variable.

2. Add a global function ColumnHeader that returns a text variable.

   

3. Add a matrix box to the form.

4. Set the following properties on the matrix box control:

   Property	Value
   Name	MatrixBox
   Editable	No
   MatrixSourceTable	Item

   

5. Set the following property on the form:

   Property	Value
   SourceExpr	Customer

   

6. Add the No. and Name fields to the left-hand side of the matrix box using the Field menu.

7. Add a textbox to the right-hand side of the matrix box.

8. Set the following property on the textbox:

   Property	Value
   SourceExpr	CalculateData

9. Add a textbox as a column header above that textbox.

10. Set the following property on the textbox:

    Property	Value
    SourceExpr	ColumnHeader

    

11. Add the following code to the ColumnHeader...