The procedure described below is one way you can specify when a field is to receive a field complement. Field complements can also be triggered by demand fields.
In the Field dialog, click the Advanced tab.
In the Field complement group box, select If empty or If filled in if you want FORMS to prompt you to type the complement if the field is empty or filled in. When you select both, FORMS always prompts you to type the complement.
Tip: You can adjust FORMS sensitivity to changes in image fields.
Optional: Type the name of a table you created in the Table box. When the table contains the field value when checked in Interpret or Verify, FORMS prompts you to type the complement for the field. (This alternative is not available for image fields, which are not interpreted by FORMS.)
The Table and If empty/If filled in options work independently of each other. Thus, when you type the name of a table and select If empty, the field complement is triggered whenever the field is empty or contains a value present in the table.
When you select If filled in, the field complement is always triggered when the field is filled in, so typing a table name would have no effect.
Click OK.
Using a table to trigger field and form complements