Master Detail Form

[Guest_imported]

I'm assigned with a task of building an application in PB.
Can anybody suggest me how to create a master detail form in PB. I have d2k background.
I have an Order Header and an Order Details. Got a Datawindow for this Order Details table. How do i logically associate this datawindow with the master table fields? Like
when the Order Header records are scrolled the relative details should be populated in the detail datawindow.
And also, on which event can i call the insertrow() function when the user wants to add a new row in the detail datawindow? Is there any other workaround for this?

Thanks in advance.

 

[Guest_imported]

I'm using PB 6.0.

 

[mrhemphill]

You write code in the 'RowFocusChanged' event in the master DW to retrieve the detail DW using what ever parameters are needed to retrieve a unique detail row.

dw_detail.Retrieve(dw_master.GetItemNumber(row, "key_id&quot)

row is a literal value in the 'RowFocusChanged' event.
"key_id" is whatever column name you are using to link the 2 datawindows.

 

[Guest_imported]

thanks a lot for the suggestion, it has worked.