C
Cdude
I have three datatables in my dataset firstly a products then a
stocklink then a stock table. Now i have linked products table to a
datagrid and the stock. The stock link table joins these 2 tables
together i have a relationship between products and stocklink and i
have a relationship between stocklink and stock. Now when i change the
selection of the product i want all the stockitems linked to that
product to display in the grid linked to stock datatable. One product
might be linked to many stock items. At the moment whenever i change
the product it only displays one of the linked items not all of them i
need them all.
stocklink then a stock table. Now i have linked products table to a
datagrid and the stock. The stock link table joins these 2 tables
together i have a relationship between products and stocklink and i
have a relationship between stocklink and stock. Now when i change the
selection of the product i want all the stockitems linked to that
product to display in the grid linked to stock datatable. One product
might be linked to many stock items. At the moment whenever i change
the product it only displays one of the linked items not all of them i
need them all.