Choose fields from left [message #577482] |
Sat, 16 February 2013 23:04 |
|
Is there any possibility of creating a selection interface similar to our report or forms wizard where user can select single fields or multiple fields together and when he clicks on the arrow those fields data to be inserted into another table.Please refer attachment.
--this is the main table
create table batch_item (batch_no varchar2(12),item_batch varchar2(12),total_batch_qty number);
insert into batch_item ('0001','a',300);
insert into batch_item ('0002','b',200);
insert into batch_item ('0003','a',102);
--after inserting the data i should be able to move this data to corresponding batches by manually selection and pushing them to a batch.
create table ct_item (item varchar2(12),item_nm varchar2(20),item_qty number);
insert into om_item values ('a','alpha',2);
insert into om_item values ('b','beta',3);
insert into om_item values ('c','gama',4);
--left side is om_item and right will have batch items where batch qty will be accumulated upon choose arrows.
|
|
|
|
Re: Choose fields from left [message #577516 is a reply to message #577500] |
Sun, 17 February 2013 21:54 |
|
thanks littlefoot for the response, the link is not opening for me too.Well , i think we need to move to ADF environment from Forms 6i which we are currently using now.If i want to migrate from forms 6i to Fussion Middleware 11g ADF, do i need to recomplile and convert all the existing forms.
|
|
|
|