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?
When you update the Stock Table on Some Event, it should check if the Current Stock <= Warning Stock. And If that is True then Put a query updating Stock Warning table with Current Stock and pdecr Values.
And then populate the DataGridView
Do mention on which event you wish to Update the stock table.