retreive from a table and insert into two tables.
I have two following tables:
item_id //from item table
I have a form for user to enter values of a purchased item. I want to populate the values(item_description) from item table to form in a combo box so that user can easily choose the item description.
the user enter all the values and select the value in item_description combo like "black laptop lenovo"
Now I want to put these values in purchase table. All is going ok up to here. But the value of item_description is entered in purchase table is "black laptop lenovo" as chosen by user..........WHILE........i want to add the item_id instead the whole description.
how I will select the item_id relevant to item_description and put it in other table.