>Thanks Naomi, when i open my local files, i do that using by example use orders (default use directory is c:\data) but when opening external files i use: use x:\statistics\orders alias est_orders, program performs both updates on orders and est_orders, then it closes est_orders and try to continue working with orders but it didn't show up. Default database is c:\data\main.dbc
Perhaps you need
use in select('est_orders') && to make sure you closed the external table and not your main Orders.
Can you also please provide some code, so we can see, what's wrong.
If it's not broken, fix it until it is.
My Blog