OraFAQ Forum: Forms » List of Values in form

Home » Developer & Programmer » Forms » List of Values in form

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

List of Values in form [message #80105]

Mon, 12 August 2002 04:16

chhan
Messages: 19
Registered: June 2002

Junior Member

Hi All,

Does anyone know how to create LOV in a form, i want to create a LOV which when i select a record, it will display the selected record in the master block, which will also display information belonging to the selected record in the detail block. e.g if i select a customer name in the LOV, this is what i want to happen:

1 IN THE MASTER BLOCK: display customer name and id.
2 IN THE DETAIL BLOCK: display order made by that customer (cust can and do have more than 1 order).

At the moment, i can only get it to display 1 order in the detail block, even though the customer have 3-4 orders.

Please help if you can.

Thanks

Chhan

Report message to a moderator

Re: List of Values in form [message #80115 is a reply to message #80105]

Mon, 12 August 2002 22:39

Tejpal Saraswat
Messages: 22
Registered: August 2002

Junior Member

Hi Chan
how to create is very simple and I hope u've already created the LOV,
ur 1st case u want to display Name and ID of customer so just enter the Select Statement when u create ur LOV and correctly assign the returned items from LOV.

and for 2nd case just use a simple trick , select the data from orders and set the condition in ur LOV query like Orders.CustomerID = Master_block.Customerid -> ( Assuming the column names) , it will display the only orders made by the customer u have selected from LOV.

best regds
Tej.

Report message to a moderator

Re: List of Values in form [message #80117 is a reply to message #80105]

Tue, 13 August 2002 03:14

chhan
Messages: 19
Registered: June 2002

Junior Member

Hi Tej.

Thanks for ur reply, i'm new to form and i'm not quite sure i understand how to follow your 2nd instruction.

I have created one LOV to do case1 and it works like a dream (it returns cust id and name).

but for the case2, do i use the same LOV to display orders or creates another LOV? or do i write a POST-CHANGE TRIGGER in the LOV txtbox? (i've written POST-CHANGE TRIGGER in LOV txtbox but got no output, so do know why).

Thanks very much for your help.

Chhan

Report message to a moderator

Previous Topic:	Re: FRM 40737 - Illegal restricted procedure
Next Topic:	calling reports from forms6.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 20:23:46 CST 2025