Home » Developer & Programmer » Forms » oracle forms... i'm new at this, please help!
oracle forms... i'm new at this, please help! [message #81508] Tue, 25 February 2003 08:34 Go to next message
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 Go to previous message
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
Previous Topic: Executables files as Setup
Next Topic: Oracle Forms 6i on Oracle 8.0.5.0 database
Goto Forum:
  


Current Time: Tue Nov 30 11:54:17 CST 2021