>>>You needed
>>>
>>>
>>>select Books.*,Acc.prin,Acc.status;
>>> From;
>>> Acc;
>>> inner join mainbase!books ;
>>>on acc.ID=books.Id;
>>>where acc.status= m.status ;
>>>into cursor return nofilter
>>>
>>m.status?
>>what is M?
>
>m. is used to distinguish memory variables (m stands for memory) from the fields. It's not really needed, but in some cases when you have a field in a table named the same as a variable, you need to use m. to tell the program you meant memory variable and not a field (fields always have precedence).
oh wow i dont need anythin thing like () or "" i thought i would since its a variable and it added the () for me like ("status")