OraFAQ Forum: Forms » POPULATING DATA FOR 3 DATA BLOCKS

Home » Developer & Programmer » Forms » POPULATING DATA FOR 3 DATA BLOCKS

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

POPULATING DATA FOR 3 DATA BLOCKS [message #166901]

Mon, 10 April 2006 03:33

Manukelana
Messages: 3
Registered: April 2006
Location: Saldanha

Junior Member

Good Day,

I have 3 Database-DataBlocks, 1 = Order 2= Customer 3=Shipping

They all have order number as there primary key attribute.

If I select the order Number from ListOfValues(LOV) Pop-up.

I want All the

Order Datails to be Populated
Shipping Details to be Populated
Customer Details to be Populated

Based on the SELECTED ORDER NUMBER(Tbl_Order.Col_Order_Number) FROM THE LOV POP UP.

I am using Forms 6i

I hope you will understand my ??tion

Report message to a moderator

Re: POPULATING DATA FOR 3 DATA BLOCKS [message #166904 is a reply to message #166901]

Mon, 10 April 2006 03:39

RAS_SANKAR
Messages: 42
Registered: March 2006
Location: India

Member

on which trigger you are displaying the lov. i how you are displaying the lov.

Report message to a moderator

Re: POPULATING DATA FOR 3 DATA BLOCKS [message #167024 is a reply to message #166901]

Mon, 10 April 2006 21:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Create your three blocks, place the fields on the same canvas, create a 'relations' between the master and detail blocks. Now create your record_group and then the LOV. Verify that it will execute in 'Enter Query mode'. Associate it with the order number in the order block. Start your form, I assume that you are at the order block, press the Enter Query icon, press the LOV icon, select your order, then press the Execute Query icon. They should all be there for you.

David

Report message to a moderator

Re: POPULATING DATA FOR 3 DATA BLOCKS [message #167100 is a reply to message #167024]

Tue, 11 April 2006 06:01

Manukelana
Messages: 3
Registered: April 2006
Location: Saldanha

Junior Member

Thank you!!!

its working

Report message to a moderator

Previous Topic:	NO DATA FOUND
Next Topic:	POP UP CALANDER AS DATE TIME INPUT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:07:14 CST 2025