| oracle forms... i'm new at this, please help! [message #81508] |
Tue, 25 February 2003 08:34  |
kim
Messages: 116
Registered: December 2001
|
Senior Member |
|
|
hey everyone, sorry if this seems simple, but i am a newbie. :)
here is what i am trying to do! first, i would like a text field w/LOV that allows the user to select a value from one table. next, i would like another text field w/LOV that is populated from another table, but depends on the value that was selected in the first LOV (through a foreign key). below these are more fields, dependant on the second LOV selection, but from the same table as well (one of these fields also contains the same information as is found in the second text field). i am unsure as to if i need two or three data blocks, or if i should create one or two relationships, etc. if someone could help me i would be very thankful...
here's a small visual!
P [[LOV]] (User selected 'P' from 'P','Q','R']]
P-1 [[LOV]] (User selected 'P-1' from 'P-1','P-2','P-3')
Table
P-1 11/30/02
P-1 12/30/02
P-1 1/31/03
|
|
|
|
| Re: oracle forms... i'm new at this, please help! [message #81525 is a reply to message #81508] |
Wed, 26 February 2003 23:28  |
Avinash Pai
Messages: 23
Registered: February 2003
|
Junior Member |
|
|
hi kim !!!
u can get this done thru only one block.
only thing is that ur P-1 [[LOV]] value depends on ur P [[LOV]] value and then the remaining field values depend again on P-1 [[LOV]] value.
code both record groups for ur LOVs 1 and 2 accordingly to get the desired outputs.
best regards,
avinash pai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
