hi nadya,
thanx for your prompt response. here's the code on which I've built my application :-



clea all
clos all

set echo off
set talk off
set cent on
set date brit
set dele on
set exac on
set confirm on
set multilocks on

set defa to c:

set path to \stock\data\databases,\stock\data\tables\common,\stock\data\tables\2001-2002
set path to \stock\forms,\stock\reports,\stock\classes,\stock\projects,\stock\menus,\stock\codes
set path to \stock\picture

cd \stock\data\databases
open data stock

cd \stock\data\tables\common
use cgdept in 0 shared
use cgstone in 0 shared
use cgpurity in 0 shared
use cglinkt in 0 shared
use cgwaxm in 0 shared
use cgwaxm1 in 0 shared

cd \stock\data\tables\2001-2002
use cgormain in 0 shared
use stock in 0 shared
use ccji1 in 0 shared
use ccji2 in 0 shared
use vwccji in 0 excl
use vwccji2 in 0 excl

**stock
public m.ref, m.aed, m.cjpnref, m.sdate,m.modelno

do form \stock\forms\frmstock