Your application only shows products' ID.  Your client wants to see product's description since product's ID does not tell them what is the product.

Remove duplicate item information from "Items" tab canvas; and add a new item to display product's description in the "Items" tab canvas.

In this Hands-On, you will learn how to:  use the POST-QUERY trigger.

 

	More Resources by Google:

Save the Form name as version 06.

Adjust the window, then select the "itemtot" column and press the "delete" function key. to remove the object since it is duplicated.

Make some window adjustment to make space for the product description.

Add a display item in the blank space and make some sizing adjustments.

Open its property palette.

Change name to “PRODUCT_DESC.”

Change "database item" to "no."

On “Prompt” type “Product Description.”

Change “Prompt Attachment edge” to " Top.”

Then close the window.

Do some window adjustments if needed.

Notice that the "product description" is not in the item table, therefore you need to create a trigger to query that information.

Create a "Post-Query" trigger for the item's “data blocks.”

Write a query to move "product description" into the display item for each "prodid" on the screen.

Compile it.

Successfully compiled.

Make an error, to see the error messages.

Correct the error and compile it again.

Successfully compiled.

Close the window.

Navigate through the application layout.

Then run the application.

Execute the query and then navigate through the application.

Check the changes.  Test the "product description."

Check if the description is right.

Close the window and save all the changes.

Now, you should practice this over and over, until you become a master at it.

Good Luck