OraFAQ Forum: Forms » How to relate two list boxes???

Home » Developer & Programmer » Forms » How to relate two list boxes??? ( oracle forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to relate two list boxes??? [message #545517]

Thu, 01 March 2012 00:03

kartheek
Messages: 17
Registered: February 2012
Location: chennai

Junior Member

Hi all,

I am creating an application in which I 'm in need to take two list boxes ..in which one mentions the country name...and the other list box mention the state names of that particular country....

I knew the approach of creating dynamic list ..but i cant do it here ..as the trigger is already assigned with another list box in the same appliaction....

so now i need to know whether it can be done using the property pallete???
please let me know
thanks in adbvance... Razz

Report message to a moderator

Re: How to relate two list boxes??? [message #545524 is a reply to message #545517]

Thu, 01 March 2012 00:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How about two lists of values? The first one:

select country from countries

The second one:

select state
from states
where country = :block.country

Report message to a moderator

Re: How to relate two list boxes??? [message #545549 is a reply to message #545524]

Thu, 01 March 2012 03:13

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can't use list items for this as it will stop you querying records. If you try to query a record where the db column that corresponds to the list item has a value the list item doesn't currently recognize then the form simply won't display it.
This scenario will be unavoidable if you are constantly changing the set of values for the state item.

Use LOV's like LF suggests.

Report message to a moderator

Re: How to relate two list boxes??? [message #545577 is a reply to message #545549]

Thu, 01 March 2012 04:06

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

have a little example regarding list values

Attachment: list.fmb
(Size: 48.00KB, Downloaded 1319 times)

Report message to a moderator

Re: How to relate two list boxes??? [message #545583 is a reply to message #545577]

Thu, 01 March 2012 04:17

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Did you not read my post? Or did you not understand it?
You can't use two list items for something like this it won't work.

Report message to a moderator

Re: How to relate two list boxes??? [message #545589 is a reply to message #545583]

Thu, 01 March 2012 04:38

kartheek
Messages: 17
Registered: February 2012
Location: chennai

Junior Member

Thanks a lot all for your replies.....and valuable support..

@mughals_king
a special thanks...learnt a new way of cretaing dynamic list without using record group....))):-

@cookie Master
my intention is to create a dynamic list without using record group ....I gt it ..thanks fr you are help..)):-

Report message to a moderator

Re: How to relate two list boxes??? [message #545592 is a reply to message #545589]

Thu, 01 March 2012 05:04

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

How you create the list is completely irrelevant. You will still have the problem with querying records.

Report message to a moderator

Previous Topic:	conecting with scanner through 6i forms
Next Topic:	how to get visual attribute name into a varible?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 04:01:16 CST 2025