- 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 (1) | 10313 | QUICK-Stop | Andrew Fuller | 9/24/1996 | 10/22/1996 | 10/4/1996 | $1.96 | QUICK-Stop |
|
||
|
|
|||||||||||
| Order Details (3) | 10314 | Rattlesnake Canyon Grocery | Nancy Davolio | 9/25/1996 | 10/23/1996 | 10/4/1996 | $74.16 | Rattlesnake Canyon Grocery |
|
||
|
|
|||||||||||
| Order Details (2) | 10315 | Island Trading | Margaret Peacock | 9/26/1996 | 10/24/1996 | 10/3/1996 | $41.76 | Island Trading |
|
||
|
|
|||||||||||
| Order Details (2) | 10316 | Rattlesnake Canyon Grocery | Nancy Davolio | 9/27/1996 | 10/25/1996 | 10/8/1996 | $150.15 | Rattlesnake Canyon Grocery |
|
||
|
|
|||||||||||
| Order Details (1) | 10317 | Lonesome Pine Restaurant | Michael Suyama | 9/30/1996 | 10/28/1996 | 10/10/1996 | $12.69 | Lonesome Pine Restaurant |
|
||
|
|
|||||||||||
| Order Details (2) | 10318 | Island Trading | Laura Callahan | 10/1/1996 | 10/29/1996 | 10/4/1996 | $4.73 | Island Trading |
|
||
|
|
|||||||||||
| Order Details (3) | 10319 | Tortuga Restaurante | Robert King | 10/2/1996 | 10/30/1996 | 10/11/1996 | $64.50 | Tortuga Restaurante |
|
||
|
|
|||||||||||
| Order Details (1) | 10320 | Wartian Herkku | Steven Buchanan | 10/3/1996 | 10/17/1996 | 10/18/1996 | $34.57 | Wartian Herkku |
|
||
|
|
|||||||||||
| Order Details (1) | 10321 | Island Trading | 3 | 10/3/1996 | 10/31/1996 | 10/11/1996 | $3.43 | Island Trading |
|
||
|
|
|||||||||||
| Order Details (1) | 10322 | Pericles Comidas clasicas | Robert King | 10/4/1996 | 11/1/1996 | 10/23/1996 | $0.40 | Pericles Comidas clasicas |
|
||
|
|
|||||||||||
| Order Details (3) | 10323 | Koniglich Essen | Margaret Peacock | 10/7/1996 | 11/4/1996 | 10/14/1996 | $4.88 | Koniglich Essen |
|
||
|
|
|||||||||||
| Order Details (5) | 10324 | Save-a-lot Markets | Anne Dodsworth | 10/8/1996 | 11/5/1996 | 10/10/1996 | $214.27 | Save-a-lot Markets |
|
||
|
|
|||||||||||
| Order Details (5) | 10325 | Koniglich Essen | Nancy Davolio | 10/9/1996 | 10/23/1996 | 10/14/1996 | $64.86 | Koniglich Essen |
|
||
|
|
|||||||||||
| Order Details (3) | 10326 | Bolido Comidas preparadas | Margaret Peacock | 10/10/1996 | 11/7/1996 | 10/14/1996 | $77.92 | Bolido Comidas preparadas |
|
||
|
|
|||||||||||
| Order Details (4) | 10327 | Folk och fa HB | Andrew Fuller | 10/11/1996 | 11/8/1996 | 10/14/1996 | $63.36 | Folk och fa HB |
|
||
|
|
|||||||||||
| Order Details (3) | 10328 | Furia Bacalhau e Frutos do Mar | Margaret Peacock | 10/14/1996 | 11/11/1996 | 10/17/1996 | $87.03 | Furia Bacalhau e Frutos do Mar |
|
||
|
|
|||||||||||
| Order Details (4) | 10329 | Split Rail Beer & Ale | Margaret Peacock | 10/15/1996 | 11/26/1996 | 10/23/1996 | $191.67 | Split Rail Beer & Ale |
|
||
|
|
|||||||||||
| Order Details (2) | 10330 | LILA-Supermercado | 3 | 10/16/1996 | 11/13/1996 | 10/28/1996 | $12.75 | LILA-Supermercado |
|
||
|
|
|||||||||||
| Order Details (1) | 10331 | Bon app' | Anne Dodsworth | 10/16/1996 | 11/27/1996 | 10/21/1996 | $10.19 | Bon app' |
|
||
|
|
|||||||||||
| Order Details (3) | 10332 | Mere Paillarde | 3 | 10/17/1996 | 11/28/1996 | 10/21/1996 | $52.84 | Mere Paillarde |
|
||
|
|
|||||||||||