Hi friends,
i have a page of page number 27 in which i have two page items and a tabular form. These three page items and tabular form are from a same table
<li> These are the form fields,
------->Order No
-------->Customer id
In the tabular form i have the following columns
<li> product number
<li> product id
<li> product name
My scenario, is
i need to fetch the corresponding product id value in the tabular form corresponding to the Customer id, soon after pressing the add row button in tabular form.
For that i tried to
write an sql query exists(that returns a single value) under the conditions section of the product id column, but it didnt worked and this is the query that i gave
select product_id
from xx_products
where customer_id = :P27_CUSTOMER_ID;
But the above query is not fetching the product id value according to the customer id value in the tabular form soon after pressing the add row button in it.
How to achieve this scenario friends.
Brgds,
Mini