:confused: i use a SQL to select some fields out from a table

e.g item_number from Inventory table

i put into a form e.g Item

then i add another filed in the form e.g. quantity

Thus i wan to save the item_number and quantity to a new table...

How do i do it?
Need i the code?

Please don't start multiple threads on the same topic.