>Sorry, I didn't pay attention. The 'Return' is a bad name for the cursor. Try to use
>
>crsResults instead for the cursor's name. Always try to avoid VFP words for your table names or field names or variables, etc.
>
>>>>>You needed
>>>>>
>>>>>

>>>>>select Books.*,Acc.prin,Acc.status;
>>>>>     From;
>>>>>         Acc;
>>>>>        inner join mainbase!books ;
>>>>>on acc.ID=books.Id;
>>>>>where acc.status= status ;
>>>>>into cursor return nofilter
>>>>>

this code doesnt work this...tells me Column status cannot be found.wont save unless i do 'status' which works for like 15 minutes