Binding Multiple Relational Tables to different Controlls
-
Hi I want to bind Relational tables with controlls ,e.g i have a table customerOrder in which Order_ID is the Primary key and this field is foreign key in CustomerTrasaction table. Now i want such a mechanisam in which some text boxes should bound to CustomerOrder Table and a data grid should bound to CustomerTrasaction table. when a person click Next, Previous Button on the form the relational records should navigate so that OrderID and the related fields comes to the text boxes which they are bound. (This is basically a parent record to which many child records exist in the child table CustomerTrasaction) and the rest of the related child fields should come to the datagrid . This navigation should work on each Next click and Previous click event. Thanks. Eman Ali Moughal Senior Software Engineer Soon Soft (pvt) Ltd www.soonsoft.com