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