- 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 (2) | 10453 | Around the Horn | Nancy Davolio | 2/21/1997 | 3/21/1997 | 2/26/1997 | $25.36 | Around the Horn |
|
||
|
|
|||||||||||
| Order Details (3) | 10454 | La maison d'Asie | Margaret Peacock | 2/21/1997 | 3/21/1997 | 2/25/1997 | $2.74 | La maison d'Asie |
|
||
|
|
|||||||||||
| Order Details (4) | 10455 | Wartian Herkku | Laura Callahan | 2/24/1997 | 4/7/1997 | 3/3/1997 | $180.45 | Wartian Herkku |
|
||
|
|
|||||||||||
| Order Details (2) | 10456 | Koniglich Essen | Laura Callahan | 2/25/1997 | 4/8/1997 | 2/28/1997 | $8.12 | Koniglich Essen |
|
||
|
|
|||||||||||
| Order Details (1) | 10457 | Koniglich Essen | Andrew Fuller | 2/25/1997 | 3/25/1997 | 3/3/1997 | $11.57 | Koniglich Essen |
|
||
|
|
|||||||||||
| Order Details (5) | 10458 | Supremes delices | Robert King | 2/26/1997 | 3/26/1997 | 3/4/1997 | $147.06 | Supremes delices |
|
||
|
|
|||||||||||
| Order Details (3) | 10459 | Victuailles en stock | Margaret Peacock | 2/27/1997 | 3/27/1997 | 2/28/1997 | $25.09 | Victuailles en stock |
|
||
|
|
|||||||||||
| Order Details (2) | 10460 | Folk och fa HB | Laura Callahan | 2/28/1997 | 3/28/1997 | 3/3/1997 | $16.27 | Folk och fa HB |
|
||
|
|
|||||||||||
| Order Details (3) | 10461 | LILA-Supermercado | Nancy Davolio | 2/28/1997 | 3/28/1997 | 3/5/1997 | $148.61 | LILA-Supermercado |
|
||
|
|
|||||||||||
| Order Details (2) | 10462 | Consolidated Holdings | Andrew Fuller | 3/3/1997 | 3/31/1997 | 3/18/1997 | $6.17 | Consolidated Holdings |
|
||
|
|
|||||||||||
| Order Details (2) | 10463 | Supremes delices | Steven Buchanan | 3/4/1997 | 4/1/1997 | 3/6/1997 | $14.78 | Supremes delices |
|
||
|
|
|||||||||||
| Order Details (4) | 10464 | Furia Bacalhau e Frutos do Mar | Margaret Peacock | 3/4/1997 | 4/1/1997 | 3/14/1997 | $89.00 | Furia Bacalhau e Frutos do Mar |
|
||
|
|
|||||||||||
| Order Details (5) | 10465 | Vaffeljernet | Nancy Davolio | 3/5/1997 | 4/2/1997 | 3/14/1997 | $145.04 | Vaffeljernet |
|
||
|
|
|||||||||||
| Order Details | 10466 | Comercio Mineiro | Margaret Peacock | 3/6/1997 | 4/3/1997 | 3/13/1997 | $11.93 | Comercio Mineiro |
|
||
|
|
|||||||||||
| Order Details (2) | 10467 | Magazzini Alimentari Riuniti | Laura Callahan | 3/6/1997 | 4/3/1997 | 3/11/1997 | $4.93 | Magazzini Alimentari Riuniti |
|
||
|
|
|||||||||||
| Order Details (2) | 10468 | Koniglich Essen | 3 | 3/7/1997 | 4/4/1997 | 3/12/1997 | $44.12 | Koniglich Essen |
|
||
|
|
|||||||||||
| Order Details (3) | 10469 | White Clover Markets | Nancy Davolio | 3/10/1997 | 4/7/1997 | 3/14/1997 | $60.18 | White Clover Markets |
|
||
|
|
|||||||||||
| Order Details (3) | 10470 | Bon app' | Margaret Peacock | 3/11/1997 | 4/8/1997 | 3/14/1997 | $64.56 | Bon app' |
|
||
|
|
|||||||||||
| Order Details (2) | 10471 | B's Beverages | Andrew Fuller | 3/11/1997 | 4/8/1997 | 3/18/1997 | $45.59 | B's Beverages |
|
||
|
|
|||||||||||
| Order Details (2) | 10472 | Seven Seas Imports | Laura Callahan | 3/12/1997 | 4/9/1997 | 3/19/1997 | $4.20 | Seven Seas Imports |
|
||
|
|
|||||||||||