Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display all child records in a grid
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Display all child records in a grid
Miscellaneous
Thread ID:
00430854
Message ID:
00430854
Views:
36
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 (1st form of formset), I have a search button(I made it, not from buttonset). Click on that search button, it goes to a second form( of formset) which is used to search for po_no. On the 2nd form, I have a combo that stores all outstanding p.o. Choose the p.o from the combo, then click the submit button. It will lookup that p.o and records from the view. If match, then display the records on the first form. I can use Find button from buttonset (comes with vfp) to search but because there are too many purchase orders that the users don't know which are still oustanding to type into the box.

My problem is it displays the parent-part and 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.
Next
Reply
Map
View

Click here to load this message in the networking platform