Home » Developer & Programmer » Forms » MASTER DETAILED FORM
MASTER DETAILED FORM [message #148628] Fri, 25 November 2005 08:13 Go to next message
nkemeno
Messages: 8
Registered: September 2005
Location: London
Junior Member
PLEASE HELP ME.
IHAVE 9 TABLES ON MY FORM ALL ARRANGED WITH TABS, BUT I WANT TO
CREATE A COMBO BOX THAT WILL HELP ME TO SELECT A SPECIFIC STUDENT
AND EVERY INFORMATION ABOUT THE STUDENT WILL CHANGE IMMEDIATELY.
BUT THE PROBLEM AM HAVING IS THAT WHEN I SELECT A STUDENT IS ONLY
STUDENT_ID THAT CHANGE,THE LEST REMAIN THE SAME.

BELOW ARE THE CODES THAT I USED.

FOR RECORD GROUP

SELECT STUDENT_NAME,TO_CHAR(STUDENT_ID)FROMSTUDENT ORDER BY NAME.

FOR WHEN_NEW_FORM_INSTANCE

DECLARE
S NUMBER;
BEGIN
S:= POPULATE_GROUP('RG_STUDENT2');
POPULATE_LIST('CBO_STUDENT','RG_STUDENT2');
END;

FOR WHEN_LIST_CHANGED

BEGIN
:STUDENT.STUDENT_ID := :STUDENT.CBO_STUDENT;
END;
Re: MASTER DETAILED FORM [message #150029 is a reply to message #148628] Tue, 06 December 2005 01:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Another TTY user. Don't shout and don't press enter at the end of each line, we can read text that is wider than 40 characters.

David
Re: MASTER DETAILED FORM [message #150030 is a reply to message #148628] Tue, 06 December 2005 01:03 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: how can i call built in procedure in from?
Next Topic: Clear Cursor Block
Goto Forum:
  


Current Time: Fri Sep 20 03:44:31 CDT 2024