>I got an "unreconized phrase/keyword" on the "WHERE" line. So i chaned it too:
>
>USE D:\Work\client\fossil_creek\lanproconversion1\for_luigi\use\stage5\legals.dbf In 0 Shared Again
>USE D:\Work\client\fossil_creek\lanproconversion1\for_luigi\use\stage5\leases.dbf In 0 Shared Again
>USE D:\VlpData\emptydata\tract.dbf In 0 Shared Again
>SELECT Leases
>SCAN ALL
> m.Lease_ID = Leases.Lease_ID
> SELECT ;
> FROM Legals ;
> INTO CURSOR leaseleagals ;
> WHERE Lower(Alltrim(legals.lease_id)) == m.Lease_ID ;
> m.TractInfo = ""
> SELECT LeaseLegals
> SCAN ALL
> m.TractInfo = tract.tra_namememo
> ENDSCAN
> USE IN LeaseLegals
> UPDATE Leases ;
> SET legal_desc = tract.tra_namememo ;
> WHERE Lower(Alltrim(legals.lease_id)) == m.Lease_ID
>ENDSCAN
>
>Now i get the error on the "INTO" line.

There should not be a ; (semicolon) at the end of the first WHERE line.

In your inner SCAN loop, you should be building the memvar, e.g.

m.TractInfo = m.TractInfo + tract.tra_namememo
* otherwise you'll just get the value of the last lease

* Also you need to use the m.TractInfo memvar in the final UPDATE,
* if you're trying to use the logic I originally presented