Hi, I have a problem as I want to populate S.Name populated when i select the SupplierID I am using MS access Database And i have in total 3 tables... In products table i have e.g. p.name=prodA prod_type=F p.Price=100 p.name=prodA p.Type=H p.Price=50 .... ... Suppliers Table: S.id=1 S.Name=InStock S.id=2 S.Name=EBM And taking data from these above two tables i am trying to insert in Supplier Windows Form (Table: Supplier Detail) SupId S.Name product_Name product_type Product_Price P.Qty Discount ProductPriceAfterdiscount (Should calculate based on what discount applied on Product_price) ...And here is the code Code: public Form1() { InitializeComponent(); // iniciate DB connection string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\EnglishBisuit\\My.mdb"; try { database = new OleDbConnection(connectionString); database.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } private void textBox1_TextChanged(object sender, EventArgs e) { String q = "Select SupplierName from Suppliers where Supplier id=" + sender; textBox2.Text = textBox2.Text.ToString(q); //something wrong here } Hope i am enough clear... Please help out Thanks, Regards,