In the last paragraph of this chapter on Pg. 84, the author challenges the reader to attempt to change the PRODUCT_ID column for the PRODUCT_NAME column in the master detail report in Order Items Detail.

I've had a problem doing this successfully. I was able to get it to work but it showed all orders instead of the specific order. To no avail, I was unable to get it to work.

A couple issues which seemed to be different than the previous exercise spanning pages 81-84.

1. The report doesn't show up as an "Interactive Report". I got around this by creating a new Region which was an Interactive Report. I then copied the following SQL into that report:

select "ORDER_ITEMS"."ORDER_ID" as "ORDER_ID",
"PRODUCTS"."PRODUCT_NAME" as "PRODUCT_NAME",
"ORDER_ITEMS"."UNIT_PRICE" as "UNIT_PRICE",
"ORDER_ITEMS"."QUANTITY" as "QUANTITY"
from "PRODUCTS" "PRODUCTS",
"ORDER_ITEMS" "ORDER_ITEMS"
where "PRODUCTS"."PRODUCT_ID"="ORDER_ITEMS"."PRODUCT _ID"
order by ORDER_ITEMS.ORDER_ID ASC

2. I also have some confusion around the difference between the Report on Products Page and the Order Items Page since the later seems to be a "Form" and how that relates back to the task at hand.

3. A non-related question, somehow along the way my pages have different numbers than the examples in the book which adds confusion while trying to follow along. Can I easily change the page name/number to reflect the same number scheme used in the book?

Thank you!

I read on into Chapter 4 and my first question was answered. I'm still processing it all thought.

Thanks,

waylock:

Athough I have been through the entire book, I had to go back and review what is actually happening.
2. In pages 81-84, one of the main points to capture is creating or using a table as your LOV (List of Values) in the Master-Detail when ordering items. When order items, the customer is not concern about the product.id per se just the product name. However the product.id is past to the detail portion of the report, in this case the product form.

3. I would not suggest to change the page numbers, because if you notice in the process page some pages are automatically set for example in a redirect, etc. However, I strongly suggest when you finish an exercise to pencil in your book the page or pages apex created. The pages I really remembered by heart is the Master-Detail page number, it is used throught out the book and I started over 3 times.

Have fun!! You will learn much.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.