Hi to all,
i get the one requirment.already one custom form ,just added the button when button button pressed a new form will opened,in that form having one filed.here logic is first form one dat block filed pass the second form parameter

994418 wrote:
Hi to all,
i get the one requirment.already one custom form ,just added the button when button button pressed a new form will opened,in that form having one filed.here logic is first form one dat block filed pass the second form parameter

1. Create a parameter (i.g. VDATE) in the second form under PARAMETER node with appropriate data type.
2. Now in the first form, take a button and write the code to open the form and pass the parameter value. For example code

once again thanks hamid giving to reply, sorry to say again same question,but here i am posted exact my requirment step by step

1)already developed a custom form on PO_headers_all table(i.g example only)

2)here first filed is po_header_id
second one is vendor_id
one more filed is authorzation_status
here iam attaching button for authorzation_filed,the status is rejected then click on the button the new form will be opened other wise show a popup message("custom_message")
3)for that i developed a new form with same table(same data block table)
here iam taking PO_header_id& vendor_id fileds(display_items)

finally my requirment is once click on he button the first form po_header_id &vendor_id filed values pass the input of the second form po_header_id &vendor_id .

once again thanks hamid giving to reply, sorry to say again same question,but here i am posted exact my requirment step by step

1)already developed a custom form on PO_headers_all table(i.g example only)

2)here first filed is po_header_id
second one is vendor_id
one more filed is authorzation_status
here iam attaching button for authorzation_filed,the status is rejected then click on the button the new form will be opened other wise show a popup message("custom_message")
3)for that i developed a new form with same table(same data block table)
here iam taking PO_header_id& vendor_id fileds(display_items)

finally my requirment is once click on he button the first form po_header_id &vendor_id filed values pass the input of the second form po_header_id &vendor_id .

Hi,
1. create two parameter in the second form under PARAMETER node with appropriate data type. (i.g. if your po_header_id &vendor_id is number parameter data type also number. Named may be P_heder_id, P_vendor_id )
2. Create a When-New-Form-Instance trigger at second form and write this

/* sample code require changes as your needs */
IF :PARAMETER.P_heder_id NOT NULL and :PARAMETER.P_vendor_id NOT NULL THEN
SET_BLOCK_PROPERTY('YOUR_BLOCK_NAME',DEFAULT_WHERE,'COLUMN_NAME='||:PARAMETER.P_heder_id||' and second_column='||:PARAMETER.P_vendor_id);
EXECUTE_QUERY;
END IF;

now in your first form button create when-button-press trigger and write