Defining Named Mappings
In OMW, select the smart field data structure, click the Design button, and select the Design Tools tab.
Click Named Mapping.
On the Named Mapping form, click Add.
The detail area includes all data items included in the data structure.
On the Add Argument List form, enter the name of the named mapping using the recommended naming conventions.
On the Named Mapping form, click the prompt data item and select the Prompt option under Origin Types.
The prompt is already set as a required data item from the data structure definition.
Click one of the data items to be fetched from a table and select the Table option under Origin Types.
Click the Browse button to access the Select a Table form.
Use the QBE (query by example) line to locate the table where the data item resides, and click Next.
On the Select a Column form, select the field that matches the data structure data item and click Finish.
On the Named Mapping form, define each of the data items that is fetched from a table using the Required option at the bottom of the form.
Define the return value data item using the Return Value option at the bottom of the form.
Note: When you select the Return Value option, the system automatically selects the Required option.