So you are using view for the grid. How about the filter option defined in the view, have you checked if you supplied the right parameter value?
>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.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."