Subject: | Re: Fitler TableFrame Records
| Date: | Sun, 8 Mar 2020 15:32:44 +1100
| From: | Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
| Newsgroups: | pnews.paradox-programming
|
It's easy. In your case, you need a secondary index on customer number.
Then, in the changevalue of the Customer_no field, just set the range to
the new customer number.
When the for opens, in the init event
<TableAlias>.switchindex("customerindex")
in the changevalue event
<TableAlias>.setrange(Customer_no.value, Customer_no.value)
Maybe issue a table refresh afterwards if the form's slow to refresh.
On 7/03/2020 9:45 pm, Kevin Baker wrote:
> Tom-
>
> Thanks for the help. I did try the setRange but for some reason, I
> can't wrap my head around how to get it to work. I've read setRange is
> faster and I'll need fast, so I may go back and try and get setRange to
> work.
>
> Thanks for the help - Kevin
|