Home » Developer & Programmer » Forms » showing wrong code - list item (urgent) (windows 7, forms 6i)
showing wrong code - list item (urgent) [message #557975] Mon, 18 June 2012 06:57 Go to next message
Messages: 20
Registered: January 2012
Location: India
Junior Member

Hi ,I have two List items list1 and list2. Here List2 depends on List1.

List2 is populating through Create_Group_From_Query when the List1 is changed.

my issue is about the value in the List2.

Here is the scenario

List1 valuse



For India - List 2 valuse

AP - 01
MP - 02
HYD- 03

For AUS - List2

AA - 04
XA - 05

List2 was populated correctly with respect to list1.

but..I have selected like below

Step1 - In List1 India was selected & in List2 AP was selected;

message(list2) shows me 01 (correct one)

step2 - In List1 AUS was selected & in list2 AA was populated by default.(I have not selected here)
message(list2) shows 01 (in correct).

which means it showing the previous value...

If I select the any value from list2 then it showing correctly.

But...In step 2 why it showing wrongly...

Re: showing wrong code - list item (urgent) [message #558150 is a reply to message #557975] Tue, 19 June 2012 13:20 Go to previous message
Messages: 12820
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do not try and use dynamic list items, it doesn't work.
You will not be able to query the data once it is entered.
Forms automatically rejects records that don't match the current list item values when querying.
So if the list item is set to india values, you will not be able to query australia records.

Use text items with LOV's instead.
Previous Topic: Forms not displaying in Server , but displaying in local
Next Topic: get a live connection to a database
Goto Forum:

Current Time: Sun Aug 20 08:48:40 CDT 2017

Total time taken to generate the page: 0.01280 seconds