APEX

I am very new to APEX

I have a simple apex report and form. This is derived from a simple sales table as follows:

sale_id number PK
sale_date date
sale_item number

now sale_item is a foreign key to a products table:

product_id number PK
product_description VARCHAR2
product_cost number.

In the apex form for sale_item, I have changed this to: Display as "Select List" and under LOV selected my LOV.
In this form it works Ok. I get a LOV for the sale_item and instead of a number, it get the description OK.

However, the report just shows the sale_item as a number, where what I really want is the description in this
report.


How can I do this ?

Thanks