Data Validation with another Table

[FC]

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.

 

[Allen Browne]

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.

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.