Multiple Record Grid

Hai,

I have Item_No, Transaction_No, Transaction_Date in a tabular format displaying 15 rows in a form.
It is the transaction entry screen to enter the transaction number, transaction date for an item.

In the same grid there are two other fields Item_Name, Item_Description which has to be populated from the master table (Item_Master) based on the Item No. in the same grid whenever Execute_Query event is triggered.

The form in tabular format will look like below :

ItemNo ItemName ItemDesc TransNo TransDate
---------------------------------------------------
I01 PEN Stationary T01 01-jan-01
I02 ABC XXXXX T02 01-feb-02

Since the above two columns Item Name and Item Description is from another table ie., master table how to display them during the Execute_Query at the block level.

Thanks in advance.

Regards,

A.Mohammed Rafi Aamiri
rafi_amr@yahoo.com

You need to write down a block level query behind 'when-validate-record' trigger, query is given below:

SELECT item_name,item_description INTO :block_name.item_name,:block_name.item_description
FROM your_table;

Here,
block_name means your block name where these all item are placed.
your_table means the name of your table from which you are fetching name nad description of item,


Note: if this query does not work, write this query item level trigger 'when-validate-item' for both of them separately.

sorry, write down this query behind block level trigger called 'POST-QUERY':

SELECT item_name,item_description INTO :block_name.item_name,:block_name.item_description
FROM your_table;

hmmm, please add the where clause also in query;

WHERE item_no=:block_name.item_no