I manage to populate a combo box with item from a database
how if I want to copy information inside that particular selection into another table ?

for example I populate combo box from table fruit
and I select apple and inside the row got amount of how many apple there is avaliable and want to add the amount to table call amount

and display this amount out

if I want to select 1 item from the displayed combo box
and add it to another table

how ?