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 understand that you want to do do 2 SELECTs and the 2nd one will be against the result of the first one.

I think that for what you need, you will be better off using a SP, this way you run all the SQL you need and the last one will be returned to the BO.

Or maybe you could use LINQ to query the data in the 1st BO, but I think that may be more hard to do if you are not familiar with LINQ.

The StrataFlix sample application have some SP sample that may help you get started.