One use for tables in FORMS is to indicate whether a field or form complement is required. If the value of a field exists in the table, then Verify prompts you to enter a complement.
Using the Manager, select ð New.
In the New object dialog, select Table and click New.
Type a name for the new table. Note that table names in FORMS are case sensitive.
Click OK. The Table dialog is displayed.
In the first box of the Update line, type only values that, if found, are to trigger FORMS to prompt you for a field or form complement during the verification process. Type one key value on each line. The Key field can contain up to 63 characters.
Click Close. FORMS saves the table automatically.
In the Advanced dialog for the chosen field, type the table name in the Field complement or Form complement group box.
If you type the name of the table in the Field complement box, the data you type manually during the Verify job is associated with the field.
If you type the name of the table in the Form complement box, the data you type manually during the Verify job is associated with the form rather than with a specific field.
The Table and If empty/If filled in options in the Advanced dialog work independently of each other. Thus, if you select If filled in, the field complement is always triggered, so typing a table name would have no effect.
As FORMS interprets and validates each form, it checks to see if the field value matches a key value in the table. If it does, the field receives the status Incomplete, and Verify prompts you to type the complement (providing Incomplete is selected as a status to be verified, as it is by default).
In order to include a field complement in your output, the transaction description must include a transaction field for it, &Fieldname.
In order to include a form complement in your output, the transaction description must contain the transaction field #Complement.
Specifying the criteria for a field complement