what is a proper statament to write in lov before creating 3 multi blocks for forms?

mr/mrs

iam studying the oracle developer form builder 2000 release 2 so in this example here i would like to know that how can we know which attributes to select from which entity that i find example one clear


you are going to create a record and lov for the student form so that you can lookup company details for each student by pressing f9 when the cursor is in the company_id
item in the student data block.

new record group based on a qeury

select company_id,company_name,city from company order by company_name.


in 2 example

desc module

module code
module name
module fee
course code


desc tutore

tutorcode
tutor name
tutor address
tutor telephone
tutor salarry
module code

is it proper if we want to click the new record group based on a query for lov is it to select module_code,module name,module_fee from model order by module_code?
in order to show module details for each tutor?so am i right?

also in this example
SQL> select * from offering;

OFFERING_ID COURSE_ID INSTRUCTOR_ID SITE_ID START_DAT MAX_NO_STUDENTS
----------- --------- ------------- --------- --------- ---------------
1001 315 700 1 16-DEC-94 24
1002 315 263 3 16-JUL-95 20
1003 915 560 7 23-NOV-96 30
1004 215 263 2 26-SEP-95 24
1005 815 978 3 15-OCT-95 20
1006 915 560 4 04-JAN-96 22
1007 615 453 4 30-SEP-95 30
1008 515 835 5 20-JUN-95 24

8 rows selected.





SQL> select * from attendance;

OFFERING_ID STUDENT_ID E AMOUNT_PAID
----------- ---------- - -----------
1001 1111 4 1000
1002 2299 1000
1003 4568 3 1200
1002 6789 4 1150
1005 9835 3 1995
1006 9842 4 1000

i understand that in offering table it got offering_id so the attendace table is defined as details so the right statment will be select offering_id,course_id,instructer_id from offering order by max_no_students ?
im not sure is it to show each details for student in offering?
and what to do with attendance table?

last example

SQL> select * from offering;

OFFERING_ID COURSE_ID INSTRUCTOR_ID SITE_ID START_DAT MAX_NO_STUDENTS
----------- --------- ------------- --------- --------- ---------------
1001 315 700 1 16-DEC-94 24
1002 315 263 3 16-JUL-95 20
1003 915 560 7 23-NOV-96 30
1004 215 263 2 26-SEP-95 24
1005 815 978 3 15-OCT-95 20
1006 915 560 4 04-JAN-96 22
1007 615 453 4 30-SEP-95 30
1008 515 835 5 20-JUN-95 24

8 rows selected.


SQL> select * from site;

SITE_ID LOCATION
--------- ------------
1 PARIS
2 BOSTON
3 LONDON
4 STOCKHOLM
5 OTTAWA
6 WASHINGTON
7 LA
8 TORONTO

8 rows selected.

is it right to write select site_id,location from site order by what? which i cant get it .

thank you