Hi All

Can I use grid like working in excel. Means, if one row finish and on enter the cursor should go to second record and so on.

My tables structure is as follows:

Master File:

1. icode c(10)
2. Full_desc c(40)
3. ..
4. ..

and Transaction file:

1. icode c(10)
2. quantity N(10,3)
3. rate N(10,2)
4. Amount N(10,2)

And, I want to enter like:

Item code Full_desc Quantity Rate Amount
--------- ------------------------------ -------- ------ --------

Please note that after entering ItemCode it should skip to Quantity and entering it should calculate amount (Quantity*rate) and the cursor should come to second row and so on...

I hope I convey whatever I need, thanks in advance.

Saify