For procedure bodies that perform some action on the database, you specify a main table. For the main table of the procedure, you can indicate whether the user can add, delete or amend records, and whether the key field is automatically incremented. You can also offer the user a choice of records in a popup window.
If the main table defines fields that link to parent tables, then these tables are automatically defined in your program. For example, on an order entry screen the customer details can be displayed and modified at the same time as the order details, since the CUSTOMER table is a parent table of the ORDER_HEADER table. Records on the parent table can be added or amended, but not deleted or auto-incremented. To access the full set of database actions, you define the table as the main table in the procedure body.