Hi Raj

>SELECT calno FROM cal WHERE id = 1 into cursor calaccess

uses:

no_of_clients=LOOKUP(cal.calno,1,cal.id)

it is simple and faster.

Fabio