OraFAQ Forum: Forms » list of item

Home » Developer & Programmer » Forms » list of item

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

list of item [message #613843]

Mon, 12 May 2014 21:08

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

Attachment: customer detatil master file.fmb
(Size: 92.00KB, Downloaded 1216 times)

Report message to a moderator

Re: list of item [message #613847 is a reply to message #613843]

Mon, 12 May 2014 23:50

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm afraid I don't understand the question. Please, rephrase it and explain a little bit more. Also, use punctuation. Putting it all into the same sentence makes it difficult to read and understand.

Report message to a moderator

Re: list of item [message #614001 is a reply to message #613847]

Wed, 14 May 2014 05:31

akhter
Messages: 30
Registered: April 2014
Location: karachi

Member

sorry i can not define in written ,so can you give me time on team viewer so i could demonstrate you that what i want ,is it possible....

Report message to a moderator

Re: list of item [message #614004 is a reply to message #614001]

Wed, 14 May 2014 05:43

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Not possible.

Report message to a moderator

Re: list of item [message #614007 is a reply to message #614004]

Wed, 14 May 2014 06:10

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

Report message to a moderator

Re: list of item [message #614008 is a reply to message #614007]

Wed, 14 May 2014 06:16

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that you need List of Values whose source is a SELECT statement that joins both tables. Something like

select d.location, a.member, a.sister, a.brother
from detail_home d,
     another_table a
where a.house_no = d.house_no
  and <additional conditions, if necessary>

Report message to a moderator

Re: list of item [message #614010 is a reply to message #614008]

Wed, 14 May 2014 06:20

akhter
Messages: 30
Registered: April 2014
Location: karachi

Member

ok,so can you tell me which trigger will be used here in forms...?

Report message to a moderator

Re: list of item [message #614012 is a reply to message #614010]

Wed, 14 May 2014 06:31

Littlefoot
Messages: 21808
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.

Report message to a moderator

Previous Topic:	How do I query the table I want to fetch data from(control block)
Next Topic:	How to make virtual screen splitter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 06:43:13 CDT 2024