Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to display all records in a grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00430593
Message ID:
00430733
Views:
14
Hi Barbara,
My 1st form doesn't have a pageframe. It's just a parent-child form to update information about purchase orders. Basically, 1 purchase order(I called p.o.) can have many items. That is why I use parent-child form. The parent part has po_no_id, date to make p.o., vendor's name. The child part is a grid that display all items(name, unit cost, quantity) which associate with the po_no_id from the parent.
This 1st form is to add, update purchase orders. There are too many p.o that become harder for the users to go to the p.o. they want. So I make a search button to go to a second form (second form of formset). On this second form, I have a combo to store outstanding p.o. and a submit button. When I click on the submit button, I have to lookup the po from the combo and records from the view, if they match, then display all information on the first form. So the users can update what they want for that particular po.
If I use the Find button from the buttonset for vfp, then the users must know which p.o they want to update first. In my case, there are too many po, the users don't remember and don't want to remember.
My problem is after I click on submit button, go back to the 1st form, the parent part is displayed, the grid is displayed also but only the first record. For example, on purchase order 10th, there are 20 items, but on the grid, only the first record shows up, the another 19 record don't.
How to make all the items show up on the grid? Please, help me if you have any ideas or experience about this.
Thank you so much.
Thanya.
*******************

Thanya,
I'm a little unclear on what you want. Does the second form (called by the search button) update both the views? Have you checked to see that both views are showing the correct data? If so have you refreshed the grid after returning to the first form?

Finally, if the main form has a pageframe with the parent data on the first page and child data on the second you may need to add "This.Refresh()" to the ...Page.Activate() code to update the page.

HTH
Barbara

>Hi all
>
> I am working on a form which is parent-child form. This form is based on 2 remote-views(purchase order is for parent part, purchase item is for child part). And the connect key between them is po_no(purchase order number).
> On that form, I have a search button(I made it, not from buttonset). Click on that search button, it goes to a second form(formset) which is used to search for po_no. If found, then display the records on the first form.
> My problem is it displays only the first record in the grid. How to display all records in the grid that match the po_no?
> Any suggestions would be great help. Thanks in advance.
Barbara Paltiel, Paltiel Inc.
Microsoft MVP - Visual FoxPro
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform