Fox007
|
| Posted: 07/26/2002, 2:20 AM |
|
Somebody have add quantiti in bookstore's items?
(check if orders's quantity is > of items's quantity, if is not > update items's quantity ( items's quantity-orders's quantity ))
Please help 
Stefano
|
|
|
 |
CodeCharge Support
|
| Posted: 07/27/2002, 6:15 AM |
|
Stefano,
you should create after insert/update event on Record form of items table. You should run two DLookUp() function in order to retrieve the number of quantity in items and orders tables (please refer to CC built in Help for more information about DLookUp() function) and then compare it. In case the orders.quantity>items.quantity you can add warning message like:
s<form_name>Err = s<form_name>Err & " please enter new quantity"
|
|
|
|
|
