Member Avatar for noselbond

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

Edited by noselbond
  • 2 Contributors
  • 1 Reply
  • 130 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by abelingaw
Member Avatar for abelingaw

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.