Need Help..
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..

I assume that you are referring to the value of the column RcvdPcs on table tblReceived.

prevent user
to released more than the received pcs.

Here's an idea, how can you released 6 items if you only received 5?