I have two tables tblRecieve and tblReleased
tblReceived --ID-RcvdPcs --1 5 tblReleased --ID-RlsdPCS --1- 2
as you can see i have received 5pcs and i already released 2pcs in same id
so the remaining pcs is 3. how do i code this to prevent user
to released more than the received pcs.
thank you so much..