option buttons [message #157284] |
Wed, 01 February 2006 07:25 |
eswaries
Messages: 41 Registered: January 2006
|
Member |
|
|
I put three option buttons and one combo list.when i click one option button I want to show one kind of list and when i click another option button i want to show another list.
for example,
i create table like that.
create table menu (menus varchar2(20),type varchar2(20));
and i insert the data like that,
menus type
dosa tiffin
idli tiffin
curd
rice lunch
lemon
rice lunch
orange
juice juice
apple
juice juice
and when i click the opiton button 1 it shows the items under
tiffin,when i cllick the option button2 it shows the items under
lunch,when i click the option three it shows the items under juice.ok.please send it.
|
|
|
Re: option buttons [message #157780 is a reply to message #157284] |
Mon, 06 February 2006 00:14 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
This sounds like a student exercise. I recommend that you pair up with another student and work on these sort of problems together.
The button should be on a separate block to the block through which you are going to retrieve your data. Each button should have a When-Button-Pressed trigger. These triggers will contain a 'Set_Block_Property(default_where)' command (read documentation or search this forum for 'default_where' examples), then you do a Go_Block('blk'), and an 'Execute_Query'. This way when you press a button the query block will have its search criteria changed and executed.
David
|
|
|