Home » Developer & Programmer » Forms » option buttons
option buttons [message #157284] Wed, 01 February 2006 07:25 Go to next message
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 Go to previous message
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
Previous Topic: Being authorize for report.
Next Topic: list box 2
Goto Forum:
  


Current Time: Fri Sep 20 05:33:13 CDT 2024