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?

Thanks in advance.