I want to use a datagrid on a VB form that allows a customer to place orders. I have a table (Products) that has all of the items to order and I populate a datagrid from that table (25 items). Next I want the user to enter quantity per each item into the datagrid (this is basically so that the program can be dynamic and the end user can add more products). I want the report (Order) to only show the items that have a quantity entered, and then add the items to the Orders table and not affect the Products table.



If you have a better idea I would be happy to entertain the idea, thanks!