Home » Developer & Programmer » Forms » how to populate city based on a selected state
icon5.gif  how to populate city based on a selected state [message #456048] Fri, 14 May 2010 05:11 Go to next message
user456
Messages: 6
Registered: May 2010
Location: INDIA
Junior Member
Hi guys this is Ravi,iam new to this forum and iam really excited about it.

I'am having a query regarding population of a list item based on another selected list item that is whenever i select the state from the combo box all the city's under that state should be automatically populated.

any help will be appreciated Cool
Re: how to populate city based on a selected state [message #456051 is a reply to message #456048] Fri, 14 May 2010 05:13 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
I really wouldn't do that. Changing list items dynamically like that is a recipe for bugs. Use LOVS instead.
Re: how to populate city based on a selected state [message #456053 is a reply to message #456051] Fri, 14 May 2010 05:18 Go to previous messageGo to next message
user456
Messages: 6
Registered: May 2010
Location: INDIA
Junior Member
Thanks for the reply dude.

ok,but how to attach an LOV to to a List item?????for text item i have an idea that we can go to the property and set the LOV
Re: how to populate city based on a selected state [message #456070 is a reply to message #456048] Fri, 14 May 2010 07:17 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
You don't attach it to the list item.
You make city a text item and and add an LOV to that which has a query that references state.
Re: how to populate city based on a selected state [message #456178 is a reply to message #456048] Sat, 15 May 2010 11:37 Go to previous message
user456
Messages: 6
Registered: May 2010
Location: INDIA
Junior Member
ok,thanks mayn will try that Smile
Previous Topic: forms
Next Topic: read_image_file problem 92101 [10g]
Goto Forum:
  


Current Time: Fri Sep 20 09:29:11 CDT 2024