yearNow=YEAR(DATE())
LOCATE FOR iordernr = m.i_ordernr and year(dOrddate)=m.yearNow
can be best:
=LOOKUP(iordernr,m.i_ordernr,iordernr)
yearNow=YEAR(DATE())
LOCATE REST FOR iordernr = m.i_ordernr and year(dOrddate)=m.yearNow
and for long table
=LOOKUP(iordernr,m.i_ordernr,iordernr)
yearNow=str(YEAR(DATE()),4)
s_ordernr=LTRIM(STR(m.i_ordernr))
LOCATE REST FOR iordernr =&s_ordernr and year(dOrddate)=&yearNow
Fabio