- 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) | 10373 | Hungry Owl All-Night Grocers | Margaret Peacock | 12/5/1996 | 1/2/1997 | 12/11/1996 | $124.12 | Hungry Owl All-Night Grocers |
|
||
|
|
|||||||||||
| Order Details (2) | 10374 | Wolski Zajazd | Nancy Davolio | 12/5/1996 | 1/2/1997 | 12/9/1996 | $3.94 | Wolski Zajazd |
|
||
|
|
|||||||||||
| Order Details (2) | 10375 | Hungry Coyote Import Store | 3 | 12/6/1996 | 1/3/1997 | 12/9/1996 | $20.12 | Hungry Coyote Import Store |
|
||
|
|
|||||||||||
| Order Details (1) | 10376 | Mere Paillarde | Nancy Davolio | 12/9/1996 | 1/6/1997 | 12/13/1996 | $20.39 | Mere Paillarde |
|
||
|
|
|||||||||||
| Order Details (2) | 10377 | Seven Seas Imports | Nancy Davolio | 12/9/1996 | 1/6/1997 | 12/13/1996 | $22.21 | Seven Seas Imports |
|
||
|
|
|||||||||||
| Order Details (1) | 10378 | Folk och fa HB | Steven Buchanan | 12/10/1996 | 1/7/1997 | 12/19/1996 | $5.44 | Folk och fa HB |
|
||
|
|
|||||||||||
| Order Details (3) | 10379 | Que Delicia | Andrew Fuller | 12/11/1996 | 1/8/1997 | 12/13/1996 | $45.03 | Que Delicia |
|
||
|
|
|||||||||||
| Order Details (4) | 10380 | Hungry Owl All-Night Grocers | Laura Callahan | 12/12/1996 | 1/9/1997 | 1/16/1997 | $35.03 | Hungry Owl All-Night Grocers |
|
||
|
|
|||||||||||
| Order Details (1) | 10381 | LILA-Supermercado | 3 | 12/12/1996 | 1/9/1997 | 12/13/1996 | $7.99 | LILA-Supermercado |
|
||
|
|
|||||||||||
| Order Details (5) | 10382 | Ernst Handel | Margaret Peacock | 12/13/1996 | 1/10/1997 | 12/16/1996 | $94.77 | Ernst Handel |
|
||
|
|
|||||||||||
| Order Details (3) | 10383 | Around the Horn | Laura Callahan | 12/16/1996 | 1/13/1997 | 12/18/1996 | $34.24 | Around the Horn |
|
||
|
|
|||||||||||
| Order Details (2) | 10384 | Berglunds snabbkop | 3 | 12/16/1996 | 1/13/1997 | 12/20/1996 | $168.64 | Berglunds snabbkop |
|
||
|
|
|||||||||||
| Order Details (3) | 10385 | Split Rail Beer & Ale | Nancy Davolio | 12/17/1996 | 1/14/1997 | 12/23/1996 | $30.96 | Split Rail Beer & Ale |
|
||
|
|
|||||||||||
| Order Details (2) | 10386 | Familia Arquibaldo | Anne Dodsworth | 12/18/1996 | 1/1/1997 | 12/25/1996 | $13.99 | Familia Arquibaldo |
|
||
|
|
|||||||||||
| Order Details (4) | 10387 | Sante Gourmet | Nancy Davolio | 12/18/1996 | 1/15/1997 | 12/20/1996 | $93.63 | Sante Gourmet |
|
||
|
|
|||||||||||
| Order Details (3) | 10388 | Seven Seas Imports | Andrew Fuller | 12/19/1996 | 1/16/1997 | 12/20/1996 | $34.86 | Seven Seas Imports |
|
||
|
|
|||||||||||
| Order Details (4) | 10389 | Bottom-Dollar Markets | Margaret Peacock | 12/20/1996 | 1/17/1997 | 12/24/1996 | $47.42 | Bottom-Dollar Markets |
|
||
|
|
|||||||||||
| Order Details (4) | 10390 | Ernst Handel | Michael Suyama | 12/23/1996 | 1/20/1997 | 12/26/1996 | $126.38 | Ernst Handel |
|
||
|
|
|||||||||||
| Order Details (1) | 10391 | Drachenblut Delikatessen | 3 | 12/23/1996 | 1/20/1997 | 12/31/1996 | $5.45 | Drachenblut Delikatessen |
|
||
|
|
|||||||||||
| Order Details (1) | 10392 | Piccolo und mehr | Andrew Fuller | 12/24/1996 | 1/21/1997 | 1/1/1997 | $122.46 | Piccolo und mehr |
|
||
|
|
|||||||||||