please send d2k form level code please.................I don't know what you mean but from the Database perspective you might need something as (take it as a template)
you should by all means expand the column and value lists as appropriate according to the subquery (final select).
insert all into master_table (ho_unit) values (the_value) into detail_table (ho_unit) values (the_value) select :selected_value the_value from dual
1. Item Type ... List item 2. Default Value .. One of the value in the list item. 3. Base Table item .... True 4. List elements ..... Elements of the list box 5. List Style Then Save button ... open write code(Trigger when button pressed) commit; clear_block(do_commit);