I have 2 tables in sql , one is called stock and the other stock warning
the stock table has columns ' Pid, pdescr,current stock, stock warning' this shows up in datagridview
2nd table(stock warning) has columns 'pdescr, current stock' showing in datagridview
in the stock table when the 'current stock' is less than the set 'stock warning ' number , i want the pdescr and current stock data to show in the stock warning table sending the data to the datagridview
how can this be done?