stock book problems
hi
[FONT='Arial Narrow','sans-serif']i have stock table and sales tbl[/FONT]
[FONT='Arial Narrow','sans-serif']fiels are pid(pk),sdate, qyt and sale table are cid,s_product, s_date, Sales, opening balance, closing balance[/FONT]
[FONT='Arial Narrow','sans-serif']I creat sales book in access form[/FONT]
[FONT='Arial Narrow','sans-serif']my table field are [/FONT]
[FONT='Arial Narrow','sans-serif']cid, product, date, Sales, opening balance, closing balance[/FONT]
[FONT='Arial Narrow','sans-serif']01 tv 01/01/2011 50 500 450 [/FONT]
[FONT='Arial Narrow','sans-serif']now problems is when i go to click process[/FONT]
[FONT='Arial Narrow','sans-serif']in next day add a new record i want privies day balance like closing balance[/FONT]
[FONT='Arial Narrow','sans-serif']should come next day opening balance and another one if opening balance is < then sale[/FONT]
[FONT='Arial Narrow','sans-serif']massage should show ("opening balance is less then sales do you want add opening balance[/FONT]
[FONT='Arial Narrow','sans-serif']cid, product, date, Sales, opening balance, closing balance[/FONT]
[FONT='Arial Narrow','sans-serif']01 tv 02/01/2011 550 500 -50[/FONT]
[FONT='Arial Narrow','sans-serif']if closing balance < then opening balance to be add stock table [/FONT]
[FONT='Arial Narrow','sans-serif']in above method how should code please explain me thank full[/FONT]
__________________
Mohamed Mohiddin
Officer
|
