USE orditems In 0 again Alias t1 USE orditems In 0 again Alias t2 USE orditems In 0 again Alias t3 USE orditems In 0 again Alias t4 Select t1 Set Filter To Recno()%4=1 Set relation to ; Recno()+1 into t2, ; Recno()+2 into t3, ; Recno()+3 into t4 Browse fields t1.line_no,t1.order_id, ; t2.line_no,t2.order_id,; t3.line_no,t3.order_id,; t4.line_no,t4.order_id
USE orditems In 0 again Alias t1 USE orditems In 0 again Alias t2 USE orditems In 0 again Alias t3 USE orditems In 0 again Alias t4 Select t1 Set Filter To Recno()<=20 Set relation to ; Recno()+20 into t2, ; Recno()+40 into t3, ; Recno()+60 into t4 Browse fields t1.line_no,t1.order_id, ; t2.line_no,t2.order_id,; t3.line_no,t3.order_id,; t4.line_no,t4.order_idWith a grid those fields would be controlsources.