Modify order
status
In this section of the tutorial you will create the
form that works with the master ,
and allows modifying its elements. The is a multi-functional form, allowing all of the regular operations:
insert, update and delete. Since adding a new order is not allowed, you
will have to delete some of the elements on page.
To build the form page, follow the next steps:
- Open the form page in (it is the page with the same name
as specified in the first ).
- Start the from the
tab of the bar.
- In the wizard's first step, make sure the right connection
and the order_ord table are selected. Click
to proceed to the second step.

- In the wizard's second step define the fields that
will be displayed in the form and taken into account when executing various
operations. Since the only changeable property is the status, remove all
the other fields except for the idsta_ord
from the grid.
To remove a field, select it and press the button. Also thanks to the user persistence, the idsta_ord
field should be configured to be displayed as a menu, and its recordset
is automatically generated based on the choices made when creating the
list (the look-up table).

- The third step provides options to set validation
rules for each field. Since you are already using a drop-down menu with
predefined options, you can safely skip this step and move on to the last
one.
- The last step allows defining general form options:
the move up/down column, skin, buttons and the use of grid when editing
multiple records. Also, you can specify whether to display the button. And since adding is not allowed, select No
in that drop-down menu:

- Now click to
close the wizard and add all the elements to the page. This will add both
elements and application logic to the
page.

- Before saving and uploading the page, also remove
the button in the image above, as
it is not necessary for the page.
Now,
when you click the button next to an
order in the master list, the
following form will be displayed:
Now the basic order management application is completed. You can improve
it by adding administrative modules for users, or even making it more
complex.