| call a form from a multi record field (merged 2) [message #583351] |
Mon, 29 April 2013 23:01  |
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
|
Member |
|
|
i have one multiple record field in frm....contain 5 field.....now i display the values...3 fields have values and two are empty...
the value of 1st field is A
2nd field is B
3rd field is C
i want if i click B it will open another form,
i want if i click c it will open another form,
it is possible?
any idea?
|
|
|
|
| Key_trigger not firing [message #583359 is a reply to message #583351] |
Tue, 30 April 2013 02:20  |
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
|
Member |
|
|
hai i have the codings...below in key_trigger...its not firing...
Begin
iF :COURSES.COURSE_NAME ='IT' THEN
CALL_FORM('E:\bala\forms_task\student_registraion.FMX',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
ELSIF :COURSES.COURSE_NAME ='MECH' THEN
CALL_FORM('E:\bala\forms_task\lov1_manual_last.fmx',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
ELSIF :COURSES.COURSE_NAME IS NULL THEN
CALL_FORM('E:\bala\forms_task\student_registraion.FMX',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
END IF;
END;
|
|
|
|
|
|
|
|
|
|
| Re: call a form from a multi record field [message #583387 is a reply to message #583380] |
Tue, 30 April 2013 06:57 |
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
|
Member |
|
|
MY need is if i click the 1st field it opens the form For example A.fmb.
if i click the 2nd field it opens the another form For example COM.fmb.
I tried in Key_enter trigger...But It doesn't fired..
and my coding is
Begin
iF :COURSES.COURSE_NAME ='IT' THEN
CALL_FORM('E:\bala\forms_task\student_registraion.FMX',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
ELSIF :COURSES.COURSE_NAME ='MECH' THEN
CALL_FORM('E:\bala\forms_task\lov1_manual_last.fmx',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
END IF;
END;
|
|
|
|
|
|
|
|
| Re: call a form from a multi record field [message #583588 is a reply to message #583574] |
Thu, 02 May 2013 01:12 |
ora_bbm
Messages: 30
Registered: March 2013
Location: Chennai
|
Member |
|
|
Finally I got the solution....Thank For your replies...
The solution is..
Data block name:COURSES
ITEM NAME:COURSE_NAME
Item contains multi record field..I have five fields.
1st field is 'IT'
1st field is 'CSE'
1st field is 'ECE'
1st field is 'MECH'
1st field is 'CIVIL'
If i click 'IT' it will open the requested form
If i click 'CSE' it will open the requested form. So i wrote the KEY-ENTER trigger in form level.The codings below
Begin
iF :COURSES.COURSE_NAME ='IT' THEN
CALL_FORM('E:\bala\forms_task\student_registraion.FMX',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
ELSIF :COURSES.COURSE_NAME ='CSE' THEN
CALL_FORM('E:\bala\forms_task\lov1_manual_last.fmx',NO_HIDE,NO_REPLACE,NO_QUERY_ONLY);
END IF;
END;
and i changed the below modifications..
Modify FMRWEB.RES and change the Forms Function Number (FFN) from 27 to 75 for the Return Key. The line should be changed to the following:
10 : 0 : "Return" : 75 : "Return"
By default, the line is displayed with an FFN of 27 and looks as follows:
10 : 0 : "Return" : 27 : "Return"
This line should NOT fire the Key-Enter trigger since the Return or Enter key is actually returning the Return function represented by the FFN of 27. The FFN of 75 represents the Enter function and will fire the Key-Enter trigger.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
