drop-down boxes.

[Former Member]

i have a selection screen with 4 select-options and 4 dropdown boxes.

i need to retrive data from the db table according to the user choice..

here my problem is

one drop down box is having 4 values atleast...

in that cast how to select data from db table ..according to user choice satisfying all the iput parameters..

inclcuing..4 dropdown boxes.

thanks,

usha.

[Former Member]

Though each dropdown list has atleast 4 values, at run time it will contain the value that is selected in the selection screen.

So do not worry, go ahead with writing query on the desired DB table using dropdown list in the where clause.

Regards

Balu

[Former Member]

thanks balu,

but my problem is lil bit deep..

suppose Ticket type is the dropdown list box....

Values in Ticket Type are: Paper Ticket, E Ticket, Both, Unaware. If user selects Paper tickets, then it has to refer the field: P_TKT; if user selects E Tickets, then it has to refer the field: E_TKT; if user selects Both, then it has to refer the field: B_TKT and if user selects Unaware, then it has to refer the field: U_TKT

in one database table..

like this I have 3 more drop down boxes...

So please suggest the solution...

thanks...

usha.