Creating O4W Forms
I. Creating a Customer Maintenance Form from the CUSTOMERS table
- From the O4W Main Menu choose O4W Form.
* From the O4W Form Menu choose Create/Modify.
* Enter the name of a new form and click on the Next button.
* From the Layout Tab we will start to define some overall characteristics about this form. The look and feel of the page can be drastically changed by creating and choosing a HTML ‘template’.
* From the Behavior Tab we can define how records will be retrieved, the number of key parts, permissions, adding menus to the form, and controlled adding, editing and deleting records. Form events can also be defined on this page.
* From the Groups Tab we can define how fields will be organized on the form. Fields can be grouped within Associations within Tabs. User defined fields may also be added to the form.
* From the Fields Tab we will select Search/Select Fields. From the Add Field To… box on the left, choose the fields to Search and place in the Search Fields box. From the Add Field To… box on the left, choose the fields to place in the Search Result Fields box.
* From the Fields Tab we will select Display on Tab. From the Add Field To… box on the left, choose the fields and place them on their appropriate tab. In this example the Contact Info box contains the following fields: ADDRESS1, ADDRESS2, TOWN, STATE, ZIP, COUNTRY, PHONE, FAX, EMAIL, WEBSITE.
* From the Fields Tab we will select Display in Association. From the Add Field To… box on the left, choose the fields and place them in their appropriate associations. In this example the Contact box contains the following fields: ID, COMPANY, FNAME, LNAME, ADDRESS1, ADDRESS2, TOWN, STATE, ZIP, COUNTRY.
* From the Search Tab we will enter the Key Entry prompt and Search field prompts. We will also define the Search Type and Comparison Type.
* From the Selection Tab we will define the characteristics of the Search Results page including field order, label name and label properties.
* On Label Properties for the ID field click the button to open the Properties window. Set the properties for this value.
* You can re-arrange the field display order by dragging a field to a new position and you can change the label name in the label text box.
* From the Edit/Display Tab we will select the All Pages tab and define the characteristics of each field’s Label, Label Display Properties, Value Display Properties, Value Input/Display Details and Value Links/Popup.
* On Label Display Properties for the ID field click the button to open the Properties window. Set the properties for this label or all labels in this association.
* On Value Display Properties for the ID field click the button to open the Properties window. Set the properties for this value or all values in this association.
* On Value Input/Display Properties for the ID field click the button to open the Properties window. Set the properties for this value.
* On Value Input/Display Properties for the COMPANY field click the button to open the Properties window. Set the properties for this value.
* Set the Value Input/Display Properties for the First Name and Last Name fields.
* Select the Contact Info tab and set the Label Display Properties, Value Display Properties, Value Input/DisplayDetails and Value Links/Popup for each field.
* On Value Input/Display Properties for the STATE field click the button to open the Properties window. Set the properties for this value.
* On Value Input/Display Properties for the ZIP field click the button to open the Properties window. Set the properties for this value.
* On Value Input/Display Properties for the COUNTRY field click the button to open the Properties window. Set the properties for this value.
* On Value Links/Popup Properties for the WEBSITE field click the button to open the Properties window. Set the properties for this value.
* Set your Label display, Value Display, Value/Input Display and Value Links Properties for all your fields on the Contact Info tab.
* Select the INVOICES tab and set the Label Display Properties, Value Display Properties, Value Input/Display Details and Value Links/Popup for each field.
* On Label Display Properties for the INV_NOS field click the button to open the Properties window. Set the properties for this value or all values in this association. Since these fields are part of a multivalue association we will set the Label/Value Position to Over/Under.
* On Value Display Properties for the INVOICE_TOTAL field click the button to open the Properties window. Set the Control Alignment to Right.
* Once you have completed setting all properties on the INVOICES tab your screen should look as follows. Click the Next button to complete the form.
* You can generate a commuter module and Save the form.
* Our CUSTOMER form has been saved and is ready to be tested.
* Enter a Customer ID, a field to search on or press the Add New Record button.
* Select a Customer ID from the Search Results form.
* The Customer Maintenance form is complete.