| how to manage many list items in forms 6i? [message #275635] |
Mon, 22 October 2007 02:54  |
nadia74
Messages: 85
Registered: August 2007
|
Member |
|
|
Hi,
I'd like to know how to manage many list items in forms 6i.
I have four list items connected to each other when i change the value in the first list the second list should populated with values related to the first list and the third list should populated with values related to the second list and so on.
The proplem is when doing this the list values changed from text to numeric (the code which stored in DB).
any ideas?
Regards
|
|
|
|
| Re: how to manage many list items in forms 6i? [message #275844 is a reply to message #275635] |
Tue, 23 October 2007 00:59  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
For 'itm1' in 'blk1', create 'record_group' one which has an unqualified 'where' clause and is used in LOV1 which you associate with 'blk1.itm1'. For 'blk1.itm2', you create 'record_group' two which has 'table.column = :blk1.itm1' in its 'where' clause and is used by LOV2. Ditto for item 3, item 4, etcetera. If the table column you want to populate is numeric and the block item is character then use 'to_char' or 'to_number' in the 'select' statement of your record group.
David
Upd: Typos
[Updated on: Tue, 23 October 2007 01:00] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
