>I have a parent-child form for purchase_order and purchase_item(1 order has many items). My purpose on this parent-child form is to view one record at a time. One the form, I made a button for REQUERY(to view another record)
>I am using Filter for the primary key in parent form(I called it po_id). And the following is the code in "Stored Procedure":
>**********************************
>procedure find_serial
>local po_id
>po_id = ""
>do form connect_update_inven_form to po_id
>if !empty(po_id)
>= requery("purchase_order")
>endif
>endproc
>**********************************
>When I run the form, I got the parent part and all child records in the child part at the first time, but when I click on the REQUERY button to view a different record, the parent part changes and the child records stay the same.
>On that REQUERY button, I just call the procedure and refresh the form. Do you have any idea to make the child part change along with the parent part?

Hi Hobby,

I usually make such forms with the parameterized view requering child records, (not parent). (and no RELATION at all). In most cases I have two grids - for parent and child records and do the REQUERY("item_view") which is the RecordSource for the grdItems grid in grdOrders.AfterRowColChange() when the row changes.

Nick