 LOV & Record Group [message #230212] |
Wed, 11 April 2007 04:08  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
