SQl Select shouldn't be affected by settings in the open tables because it doesn't use them. Instead it opens tables in other work areas with command similar to USE AGAIN.
>Hi Sergey
>
>Yes I had just got to that and my table does get updated by my view doesn't pick up the the changes.
>
>Even figured out it was my inner join statement that was preventing me from seeing my added records (was using BROSWER) to add and not using valid keys
>
>perhaps you can explain something for me. Why does the select statement bypass the active key when there is a filter on the current index???
>
>Any ideas???.
>
>
>Regards
>Geoff Scott
--sb--