Passing a value as a search criteria

[user3427690]

I do want to filter the results according to the input in the search-box, i will explain how it should work 1) Initially it should display the complete results "for each customer" 2) Then on results if i press "s" a search box should appear which will prompt for customer number 3) On giving the company number, the results should be displayed only for that company.

1. for each customer where customer.no = num no-lock :
2. tmpname.name = customer.name
3. tmpname.no = customer.no
4. end.
5. 
   if num = ""
   
   
6. 
   for each customer no -lock :
   
   
7. create tmptable
8. tmpname.name = customer.name
9. tmpname.no = customer.no
10. end.

the above table will display results for all the companies,

this form will prompt for customer.no 164. form num 165. customer.no 166. with frame f1. 167. update num with frame f1.

Now, I dont know how to pass this num back to line number 24. to filter the search only for the given customer number. Your help is much appreciated. Thanks in advance.

Continue reading...