Dear Sir,

I am writing to u in great expectations from you.

Please help me in grids. I have written what requirement I need. Hope it will help u to understand easily. I have also attached a jpeg file (grid1) which shows the view how it will look after 1 or two entries. I just need the code for gird portion.

You can see in the image that the grid contains columns as serial, product, quantitym rate, diff, amount....
A label with local currency and value is also shown,
(LETS TAKE PURCHASE ENTRY FORM)
When I open the form, the grid will show blank in all rows. The mouse cursor will wait for product code, which is stored in table. Suppose that table contains only 3 fields i.e code, name, rate and data is already present. (say PROD_MAST.DBF)
Now when I type the code in product column (or click the magnifying glass) another form will popup to show list of product codes present. In this example I have selected product code as 'PTB003'. after loosing focus from product colum the mouse cursor will wait for quantity where as the rate colum will show the corresponding rate (say 3.15) that is already present in the product master table (PROD_MAST.DBF). Suppose I have entered a code which is not present in PROD_MAST.DBF, then an error box will come to tell the code is wrong. Then , When I enter quantity say 750, the amount column will now calculate quantity*rate (750 x 3.15) = 2362.50. I will forcefully then give the roundoff value in diff column say 0.50. Now the amount column will show 2363.00. When this row is completed the mouse cursor will wait for second row data (if I need more rows. There should not be no limit on how many records I want). The total amount of all the amount column will be added and is thus shown in the 'local currency label' as 2593.00.

Please tell me how can I do this? Will it be easy to create a cursor and appending a single blank row when form is loaded. When all the rows are entered,the data will be appended to another table say "PURCHASE.DBF". Suggest some other way.

The jpeg file a completed program done by a company where I cannot see the code. I have done all other programs except this grid one. I am developing this software for a small shop.

Hope you can understand what I require. Feel free to call at + 91 99322 64130 or mail me.

I am using VFP 6.0. (If any one can give me VFP 8.0 or above then it will also be a great help.

Best regards

Gurmeet Singh



--------------------------------------------------------------------------------