Yes, both tables are ordered. I was doig a SEEK() command with an IF condition.

Here's partial code:

As soon as I SELECT the BATCHN table, the record in the WORK table returns to the record it had been on, although I specifically saw that it was on the second record on the second pass (loop).

WITH ThisForm
	SELECT WORK
	SCAN	&& FOR WORK.Order_Num = tmpOrders.Order_num
		SELECT BatchN
		lcOrderNo =Work.Order_Num
		lcPart_Num=Work.Part_Num
			
		*SELECT BATCHN
		IF !SEEK(lcOrderNo) && 1st time in to the BATCHN table..
			* If there is no record yet, make a new one.
			APPEND BLANK
			* Put in the data for the first line item.