oracle10g - Create drop down list to populate foreign key fields -

i new oracle 10g. using build forms. have created tables in sql+ , have designed forms. having problem foreign key fields in form.

i have table named class, class has 4 foreign keys represented on class form

1. r_id primary key of table called room
2. e_id primary key of table called exam
3. t_id primary key of table called term
4. sub_id primary key of table called subject

in class form want user able create or update record of class. user friendliness want when put cursor on 1 of foreign key field enter value, want corresponding name parent table displayed drop down list instead/as numerical foreign key value. user's choice populate foreign key field of class table so

if r_id = rm001 , name of room in parent table chemistry lab. want user see chemistry lab , choose populates class table in database rm001

i have created navigation manually via buttons, last thing have , im stumped. want user able click field , drop down list automatically appears.

any ideas? much

found answer people seeking information

use list of values (lov) wizard.
build query in wizard selecting attributes of table want( parent table of foreign key) set return value foreign key in child table assign button execute lov created

this works