- Before deleting a record check if related records exist. (You can\'t delete record in the Order table if there are some records in the Order Details table for selected order).
- Show quantity of deleted records.
- Blue text when order is complited
- Can` t edit order when is complited (hide edit controls)
- Javascript Event - AutoUpdate Total Price Field
- Lookup Wizard on product Field - autofill Unit Price filed and Discount filed
- Totals for Order Details
| Order ID | Customer | Employee | Order Date | Required Date | Shipped Date | Freight | Ship Name | Complited | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Order Details (3) | 10333 | Wartian Herkku | Steven Buchanan | 10/18/1996 | 11/15/1996 | 10/25/1996 | $0.59 | Wartian Herkku |
|
||
|
|
|||||||||||
| Order Details (2) | 10334 | Victuailles en stock | Laura Callahan | 10/21/1996 | 11/18/1996 | 10/28/1996 | $8.56 | Victuailles en stock |
|
||
|
|
|||||||||||
| Order Details (4) | 10335 | Hungry Owl All-Night Grocers | Robert King | 10/22/1996 | 11/19/1996 | 10/24/1996 | $42.11 | Hungry Owl All-Night Grocers |
|
||
|
|
|||||||||||
| Order Details (1) | 10336 | Princesa Isabel Vinhos | Robert King | 10/23/1996 | 11/20/1996 | 10/25/1996 | $15.51 | Princesa Isabel Vinhos |
|
||
|
|
|||||||||||
| Order Details (5) | 10337 | Frankenversand | Margaret Peacock | 10/24/1996 | 11/21/1996 | 10/29/1996 | $108.26 | Frankenversand |
|
||
|
|
|||||||||||
| Order Details (2) | 10338 | Old World Delicatessen | Margaret Peacock | 10/25/1996 | 11/22/1996 | 10/29/1996 | $84.21 | Old World Delicatessen |
|
||
|
|
|||||||||||
| Order Details (3) | 10339 | Mere Paillarde | Andrew Fuller | 10/28/1996 | 11/25/1996 | 11/4/1996 | $15.66 | Mere Paillarde |
|
||
|
|
|||||||||||
| Order Details (3) | 10340 | Bon app' | Nancy Davolio | 10/29/1996 | 11/26/1996 | 11/8/1996 | $166.31 | Bon app' |
|
||
|
|
|||||||||||
| Order Details (2) | 10341 | Simons bistro | Robert King | 10/29/1996 | 11/26/1996 | 11/5/1996 | $26.78 | Simons bistro |
|
||
|
|
|||||||||||
| Order Details (4) | 10342 | Frankenversand | Margaret Peacock | 10/30/1996 | 11/13/1996 | 11/4/1996 | $54.83 | Frankenversand |
|
||
|
|
|||||||||||
| Order Details (3) | 10343 | Lehmanns Marktstand | Margaret Peacock | 10/31/1996 | 11/28/1996 | 11/6/1996 | $110.37 | Lehmanns Marktstand |
|
||
|
|
|||||||||||
| Order Details (2) | 10344 | White Clover Markets | Margaret Peacock | 11/1/1996 | 11/29/1996 | 11/5/1996 | $23.29 | White Clover Markets |
|
||
|
|
|||||||||||
| Order Details (3) | 10345 | QUICK-Stop | Andrew Fuller | 11/4/1996 | 12/2/1996 | 11/11/1996 | $249.06 | QUICK-Stop |
|
||
|
|
|||||||||||
| Order Details (2) | 10346 | Rattlesnake Canyon Grocery | 3 | 11/5/1996 | 12/17/1996 | 11/8/1996 | $142.08 | Rattlesnake Canyon Grocery |
|
||
|
|
|||||||||||
| Order Details (4) | 10347 | Familia Arquibaldo | Margaret Peacock | 11/6/1996 | 12/4/1996 | 11/8/1996 | $3.10 | Familia Arquibaldo |
|
||
|
|
|||||||||||
| Order Details (2) | 10348 | Die Wandernde Kuh | Margaret Peacock | 11/7/1996 | 12/5/1996 | 11/15/1996 | $0.78 | Die Wandernde Kuh |
|
||
|
|
|||||||||||
| Order Details (1) | 10349 | Split Rail Beer & Ale | Robert King | 11/8/1996 | 12/6/1996 | 11/15/1996 | $8.63 | Split Rail Beer & Ale |
|
||
|
|
|||||||||||
| Order Details (2) | 10350 | La maison d'Asie | Michael Suyama | 11/11/1996 | 12/9/1996 | 12/3/1996 | $64.19 | La maison d'Asie |
|
||
|
|
|||||||||||
| Order Details (4) | 10351 | Ernst Handel | Nancy Davolio | 11/11/1996 | 12/9/1996 | 11/20/1996 | $162.33 | Ernst Handel |
|
||
|
|
|||||||||||
| Order Details (2) | 10352 | Furia Bacalhau e Frutos do Mar | 3 | 11/12/1996 | 11/26/1996 | 11/18/1996 | $1.30 | Furia Bacalhau e Frutos do Mar |
|
||
|
|
|||||||||||