>SELECT Orders > lcOrdersOldOrder = ORDER() > SET ORDER TO order_id > SELECT orderitems > lcItemsOldOrder = ORDER() > SET ORDER TO order_id > SELECT c_Orders > SCAN > lcOrdNum = order_id > SELECT Orders > SEEK lcOrdNum > IF FOUND() > REPLACE shipdate WITH DATE() > ELSE > WAIT WINDOW AT 20,20 ' Order not found ' > ENDIF > SELECT orderitems *** Pause here!!! > REPLACE shipped WITH DATE() FOR order_id = lcOrdNum > > ENDSCAN > > >You code looks simple enough. Are there any filters on the OrderItems table?