hi,i have two tables with different data in each.
Table 1 holds order information
order id - primary key
order no
supplier
person making order
table 2 holds details of each order
id - primary key
order no - same as above table
item
qty
unit price
Id like to put 2 datagrids on my form,one listing the details of table 1,and the other listsing the details of table 2.
What i want is : form open and loads all orders from table 1 into datagrid 1,
user the selects an order from datagrid 1,and then datagrid 2 is populated with data relating to that order - ie has the same order no,so i can then edit the data and write it back to the db.
Table 1 holds order information
order id - primary key
order no
supplier
person making order
table 2 holds details of each order
id - primary key
order no - same as above table
item
qty
unit price
Id like to put 2 datagrids on my form,one listing the details of table 1,and the other listsing the details of table 2.
What i want is : form open and loads all orders from table 1 into datagrid 1,
user the selects an order from datagrid 1,and then datagrid 2 is populated with data relating to that order - ie has the same order no,so i can then edit the data and write it back to the db.