Hi all,
i have new requirement of 2 forms , both forms has common field document number in headers block, after both forms saved , in form 1 i kept button, once button pressed form 2 is opening ,but i need to view form 2 in auto query mode with same document number as form 1 having . only to view form 2 data in form 1 by using button .
please suggest..
i have tried many triggers in form 1 button
when button pressed trigger
OPEN_FORM('/orasb/DEVAP/apps/apps_st/appl/xxcust/12.0.0/forms/US/XX_form_2.fmx'); --working fine second form opening
--Go_Block('XX_my_2nd_form block');
--enter_query;
--Execute_Query;
Go_Block(<name of my database block>);
Execute_Query;
__________________________________i tried in key next item also_
declare
a number;
begin
select Table1.doc_no into a from Table1 where doc_no=:2nd_form_table.doc_no;
if a <> 0 then
set_block_property('2nd table' WHERE 'column_name'=:column_name);
execute_query(no_validate);
end if;
next_item;
end;
please suggest some solution