Putting data to data grid

[Eashrak]

Hi

I create two table (Table1 & Table 2) in my SQL server. Table1 have "orderno", quantity and table2 have "orderno" and size.i create one "form" which is connected through 2 (Two) ADO to conect the tables. i made text box for table1 and datagrid for table2

my question is " when i enter data on the ordrerno field in the table1 the table2 "orderno" should will show the same data on the grid

any help is appreciated

eashta

[One Handed Man]

Create a relation within the dataset containing the two tables. Then point
the datasource of the details box to the relation.

Regards - OHM

Eashrak wrote:

Hi,

I create two table (Table1 & Table 2) in my SQL server. Table1 have
"orderno", quantity and table2 have "orderno" and size.i create one
"form" which is connected through 2 (Two) ADO to conect the tables. i
made text box for table1 and datagrid for table2.

my question is " when i enter data on the ordrerno field in the
table1 the table2 "orderno" should will show the same data on the
grid.

any help is appreciated.

eashtak

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

[Eashrak]

Thank
----- One Handed Man wrote: ----

Create a relation within the dataset containing the two tables. Then poin
the datasource of the details box to the relation

Regards - OH

Eashrak wrote

Hi

I create two table (Table1 & Table 2) in my SQL server. Table1 hav

"orderno", quantity and table2 have "orderno" and size.i create on
"form" which is connected through 2 (Two) ADO to conect the tables.
made text box for table1 and datagrid for table2

my question is " when i enter data on the ordrerno field in th

table1 the table2 "orderno" should will show the same data on th
grid

any help is appreciated
eashta

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Co