Define the Form Layout

Select Maintain/Form Structure/Define and click the Layout button. You must have selected and defined a form on the previous tabs first. You can also go to the Add-Ins tab/Controller/Forms/Layout in Excel 2007 and select the desired form.

You can click the Create Layout button to show the content of the form as defined in Maintain/Form Structure/Define. Codes and texts appear as they were defined on the other tabs, while a formula, =.Put Value and its parameters, appears in the cells that will be used for entering values in the data entry window. The formula determines where the entered values will be stored in the database. In the cell the formula is shown as a value, but if you activate the cell you can edit the formula manually.

If you change the row definition or column definition and wish to update the contents of the Layouttab, you should click the Updatebutton instead of the Create layoutbutton. The Updatebutton keeps all existing formatting and only adds or removes the changed rows/columns, which were specified in the row definition or column definition that the layout is based on. The Create layoutbutton deletes all previous formatting and regenerates the layout.

For information about the Controller menu in Excel, see The Controller menu in Microsoft Excel.