list of item [message #613843] |
Mon, 12 May 2014 21:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/432345a5779d1fe541d7db24ab29553c?s=64&d=mm&r=g) |
akhter
Messages: 30 Registered: April 2014 Location: karachi
|
Member |
|
|
dear i created list of item and trigger is WHEN-LIST-CHANGED applied now i want that what i change values on which col in which applied trigger WHEN-LIST-CHANGED it must change all table values means i applied fk key,,,,,,,
please help me out
for your convience i attached file
|
|
|
|
|
|
Re: list of item [message #614007 is a reply to message #614004] |
Wed, 14 May 2014 06:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/432345a5779d1fe541d7db24ab29553c?s=64&d=mm&r=g) |
akhter
Messages: 30 Registered: April 2014 Location: karachi
|
Member |
|
|
now try to get from this example,i have created table(detail_home) in which column is house no,location, just two col in this table ,
then i created another table in which i created four column which are hosue no,member,sister,brother.i applied FK on house no column, so i want that when i ever select house no from item list(which is in form) ,so it take values of concern house detail ,then i select second house no then it must take second house no detail......i think so you get it please help me out it has been long time
|
|
|
|
|
Re: list of item [message #614012 is a reply to message #614010] |
Wed, 14 May 2014 06:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You don't need any trigger for that. List of Values can be "attached" to an item (or many items). There's the "List of values" keyboard shortcut (on my 10g Forms, it is F9 function key; see "Help - Show keys" if you don't know which one is used in your case) so - when focus is on that item, just press F9.
Or, you can even show it automatically - just set LoV's "Automatic Display" property to "Yes". Review other properties as well (such as item's "Validate from List" which won't allow you to enter values different from the ones returned by the LoV).
If you insist, you can create a KEY-LISTVAL trigger on that item.
|
|
|