Data Validation with another Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While issuing a sales order, it have to validate the stock level first. For example, when someone wanna buy qty 200 of product 'A', it should check invenotry table whether product 'A' has qty 200 or more. If qty is not enough, qty in Sales Order should be rejected.

Thanks a lot.
 
If you have stored the current quantity in a field, use DLookup() to
retrieve it. See:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

Keeping the stored value up to date is another issue. For an introduction to
how to approach that, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

FC said:
While issuing a sales order, it have to validate the stock level first.
Click to expand...
For example, when someone wanna buy qty 200 of product 'A', it should check
invenotry table whether product 'A' has qty 200 or more. If qty is not
enough, qty in Sales Order should be rejected.
 
Back
Top