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
Srini_DEV
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

India

AUS


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...

Report message to a moderator

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
cookiemonster
Messages: 13925
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.

Report message to a moderator

Previous Topic: Inserting Multiple Records when we Press Button In the FOrms
Next Topic: get a live connection to a database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 22:32:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.