Home » Developer & Programmer » Forms » LOV & Record Group
icon8.gif  LOV & Record Group [message #230212] Wed, 11 April 2007 04:08 Go to next message
rakas22
Messages: 29
Registered: May 2006
Junior Member
Hi all,

I have two items called Country, locations associated with LOVs.

When i select value from Country LOV it should fetch the corresponidng values in the next LOV associated with locations item.

Ex:

if i select INDIA then locations LOV should give indian locations,
if i select USA then locations LOV should give USA locations.

like that in run time i have to change the record group query.

Thank u all.

Re: LOV & Record Group [message #230306 is a reply to message #230212] Wed, 11 April 2007 08:51 Go to previous message
Sudha S Teki
Messages: 11
Registered: April 2007
Junior Member
Hi,

You Create LOVs like this.

1. select all tabname1.locid,tabname1.locnm
from tabname1 order by tabname1.locnm

create one temporary item like tlocid in block.

2. SELECT ALL tabname2.colid, tabname2.coldesc
from tabname2 where tabname2.locid = :block.tlocid

Ok.
Previous Topic: Export data from Form 6 to Excel
Next Topic: Forms query
Goto Forum:
  


Current Time: Sun Dec 11 00:13:23 CST 2016

Total time taken to generate the page: 0.09311 seconds