>>>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")