problems with updating information from 2 tables

Question

Hi everybody! I have 2 tables in my database : Customers (id_cust, name, surname) and Orders(id_cust, product_id); id_cust is the foreign key on table Customers. I want to show these columns in DataGridView: id_cust | name | surname | product_id I have problem because I use DataAdapter and I have this SelectCommand: "Select id_cust,name,surname,product_id from Customers,Orders where Customers.id_cust = Orders.id_cust)" and I really get everything to my DataGridView but I have problem with Updating data. The wizard can't give me the UpdateCommand, and DeleteCommand, and InsertCommand. Do You know how can I upadate my 2 tables :Customers, Orders when I have everything in one DataGridView. Please help me! Thank's for any reply!