You're problem may be that you need to issue a TABLEUPDATE() on customers after you update the data in that table. A SELECT only reads from data on file, not the current work area, which is why you may not be seeing the updated data that you want to see.