Oracle Designer Tutorial |
In lesson 7 you generated (and possibly used) a form that had been given default characteristics based on design information supplied earlier. You can now change the default characteristics to meet your further requirements. One way to do this is to use the Navigator to find the object that you want to change (e.g., the Discount Day field), then open the Property Palette and make the changes. Another way is to open a diagram so that the objects can be easily seen, then to open the Property Palette from the diagram. The latter method is described in this lesson.
By default, the form generator will provide a menu item for opening a list of values for a field on a form. As an alternative, you can provide a list of values by making the field a drop-down list.
An automatically generated attribute is given a name that might not be meaningful when used as a prompt on a generated form. You can change such prompts to a more meaningful one.
To set up a drop-down list and change a field prompt on the Priced Products form.
If the Property Palette is already open, you display the correct properties by single clicking SIZE_CODE on the diagram.
If the Property Palette is not already open, you open it by selecting OptionsUse Property Palette
then double clicking the A icon next to SIZE_CODE.
The Property Palette title bar will say "TUTORIAL: Bound Item Properties".
In the default generated form that you have already seen, the fields for inputting Products data appeared on the Priced Products form. Now we are going to assume that Speedy Pizza will store product data on the database as a separate operation, and that the "Add new product to the menu" process uses this information to create specific "menu" items. For example, Speedy Pizza has a basic product called "Ham and mushroom supreme", one of its pizzas. This is available in small, medium and large sizes, and each of these variants must appear on its menu. This is achieved through the Priced Products form, by creating separate records for small, medium and large pizzas, all incorporating "Ham and mushroom supreme" from the Products lookup table.
To change the Products table into a lookup table.
A lookup link appears on the diagram. The crow's foot always points to the table on the left, which is the usage that contains the foreign key column.
Leave the Design Editor open for the next lesson.
In this lesson you:
|
|