Adding a FlowField to a table

FlowFields are fields that are not actually stored in the database. They are calculated fields that the user can call upon instead of performing the calculation themselves. This recipe will show you how to add a FlowField to your tables.

How to do it...

1. Follow the steps from the Creating a Table recipe to create a table.

2. Add the following field to the table:

   Field No.	Field Name	Data Type	Length
   10	Sell-to Customer No.	Code	20

3. View the Properties for this field (Shift + F4).

4. Set the following properties:

   Property	Value
   FieldClass	FlowField
   CalcFormula	Lookup("Sales Invoice Header"."Sell-to Customer No." WHERE (No.=FIELD(Document No.)))
   Editable	No

5. Close the Properties Window.

6. Save and close your table.

How it works...

To start, we create a field like any other field. It should have an ID number, name, and type. In order to make it a FlowField, we have to change the property named FieldClass. This tells the system whether or not this is an...