Hi,

I'm using Visual Studio C# 2005

I have two tables in a Access database.

Table1: Products
ProductID
ProductName
ProductSellingPrice
ProductCostPrice


Table2: Transactions
TransactionID
TransactionType
ProductID
TransactionQuantity
TransactionAmount

I have created a form for the 'Transactions'-table. The form contains
a combo box which displays Product-Names instead of the ProductID. So the user selects the required product and types in the required quantity (TransactionQuantity), which is then used to calculate the TransactionAmount.

However, this is where I am stuck, as I can not figure out the code
required to obtain the selling price of the selected product in the combo box, which then needs to be multiplied by the quantity typed in by the user and displayed in a textbox.

If more information is needed please ask!!

thanks for any help!

Populate the two table in DataSet
use hashtable to store productId and Productname.
Use productId as Key and Productname as value of that Key.
SelectionChange Event of combobox pass qry "Select productname from products where productId = '" + Combobox1.SelectedValue.ToString() + "'"
I hope it will give the desired result.

Bijgupt