hi

I have two following tables:

[u]Item table:</u>
item_id
item_description


[u]purchase table:</u>
pur_id
pur_date
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.

thanks

Saifi