I created purchase invoice data entry form for stock in. I want to allow user to able to transfer item by selecting item records in purchase invoice line items.

My design is that, user can select line item record, click on "Transfer" button. Customized Transfer form will be shown as below:

The fields above is in un-normalized form. However, my tables are designed in normalized form.

How to have temporary table like VFP cursor for temporary editing?

Thank you

I am glad you've seen some light at the end of the tunnel.

Well, I have never used a SP at all, but sounded like SP would be a choice here and I am happy you where able to think about it and find some used for them.

Now it is working like a charm. With vfp stored procedures I think I have resolved most of my "problems" 

Guess now I know where to go if I need to use SP in VFP

It is all about share, problems and solutions!!!!