Home » Developer & Programmer » Forms » LIST ITEM (windows)
LIST ITEM [message #687969] Thu, 03 August 2023 08:07 Go to next message
HasnainAli
Messages: 6
Registered: September 2018
Junior Member
A.O.A
hi every one.

my question is that:
I have a LIST_ITEM with name 'Country' and other LIST_ITEM name is 'province ' when i select the values from country list item then in
province list items all provience of that country show in next list item.

Country: Pakistan selectted
Provience :PUNJAB
          SINDH
          KPK
          Balochistan
how this is possibe in oracle form builder 6i.

Re: LIST ITEM [message #687971 is a reply to message #687969] Thu, 03 August 2023 14:54 Go to previous messageGo to next message
Littlefoot
Messages: 21802
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Modify PROVINCE field's List of Values query and include WHERE clause which references COUNTRY field. For example:

select province_name
from provinces
where country = :ADDRESS.COUNTRY;
(where ADDRESS is a block name, and COUNTRY is a field name).
Re: LIST ITEM [message #687975 is a reply to message #687971] Fri, 04 August 2023 02:11 Go to previous messageGo to next message
HasnainAli
Messages: 6
Registered: September 2018
Junior Member
thnaks littlefoot for response .
issue resolved.
Re: LIST ITEM [message #687978 is a reply to message #687975] Sat, 05 August 2023 09:10 Go to previous message
Littlefoot
Messages: 21802
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're welcome.
Previous Topic: TEXT_IO read and insert into table
Next Topic: Background Image set Size
Goto Forum:
  


Current Time: Thu Feb 29 23:30:59 CST 2024