- 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) | 10251 | Victuailles en stock | 3 | 7/8/1996 | 8/5/1996 | 7/15/1996 | $41.36 | Victuailles en stock |
|
||
|
|
|||||||||||
| Order Details (2) | 10252 | Supremes delices | Margaret Peacock | 7/9/1996 | 8/6/1996 | 7/11/1996 | $51.30 | Supremes delices |
|
||
|
|
|||||||||||
| Order Details (2) | 10253 | Hanari Carnes | 3 | 7/9/1996 | 7/25/1996 | 7/11/1996 | $58.17 | Hanari Carnes |
|
||
|
|
|||||||||||
| Order Details (2) | 10254 | Chop-suey Chinese | Steven Buchanan | 7/11/1996 | 8/8/1996 | 7/23/1996 | $22.98 | Chop-suey Chinese |
|
||
|
|
|||||||||||
| Order Details (3) | 10255 | Richter Supermarkt | Anne Dodsworth | 7/12/1996 | 8/9/1996 | 7/15/1996 | $148.33 | Richter Supermarkt |
|
||
|
|
|||||||||||
| Order Details (4) | 10256 | Wellington Importadora | 3 | 7/15/1996 | 8/12/1996 | 7/17/1996 | $13.97 | Wellington Importadora |
|
||
|
|
|||||||||||
| Order Details (3) | 10257 | HILARION-Abastos | Margaret Peacock | 7/16/1996 | 8/13/1996 | 7/22/1996 | $81.91 | HILARION-Abastos |
|
||
|
|
|||||||||||
| Order Details (1) | 10259 | Centro comercial Moctezuma | Margaret Peacock | 7/18/1996 | 8/15/1996 | 7/25/1996 | $3.25 | Centro comercial Moctezuma |
|
||
|
|
|||||||||||
| Order Details (4) | 10260 | Old World Delicatessen | Margaret Peacock | 7/19/1996 | 8/16/1996 | 7/29/1996 | $55.09 | Ottilies Kaseladen |
|
||
|
|
|||||||||||
| Order Details (3) | 10261 | Que Delicia | Margaret Peacock | 7/19/1996 | 8/16/1996 | 7/30/1996 | $3.05 | Que Delicia |
|
||
|
|
|||||||||||
| Order Details (2) | 10262 | Rattlesnake Canyon Grocery | Laura Callahan | 7/22/1996 | 8/19/1996 | 7/25/1996 | $48.29 | Rattlesnake Canyon Grocery |
|
||
|
|
|||||||||||
| Order Details (4) | 10263 | Ernst Handel | Anne Dodsworth | 7/23/1996 | 8/20/1996 | 7/31/1996 | $146.06 | Ernst Handel |
|
||
|
|
|||||||||||
| Order Details (2) | 10264 | Folk och fa HB | Michael Suyama | 7/24/1996 | 8/21/1996 | 8/23/1996 | $3.67 | Folk och fa HB |
|
||
|
|
|||||||||||
| Order Details (2) | 10265 | Blondel pere et fils | Andrew Fuller | 7/25/1996 | 8/22/1996 | 8/12/1996 | $55.28 | Blondel pere et fils |
|
||
|
|
|||||||||||
| Order Details | 10266 | Wartian Herkku | 3 | 7/26/1996 | 9/6/1996 | 7/31/1996 | $25.73 | Wartian Herkku |
|
||
|
|
|||||||||||
| Order Details (3) | 10267 | Frankenversand | Margaret Peacock | 7/29/1996 | 8/26/1996 | 8/6/1996 | $208.58 | Frankenversand |
|
||
|
|
|||||||||||
| Order Details (2) | 10268 | GROSELLA-Restaurante | Laura Callahan | 7/30/1996 | 8/27/1996 | 8/2/1996 | $66.29 | GROSELLA-Restaurante |
|
||
|
|
|||||||||||
| Order Details (2) | 10269 | White Clover Markets | Steven Buchanan | 7/31/1996 | 8/14/1996 | 8/9/1996 | $4.56 | White Clover Markets |
|
||
|
|
|||||||||||
| Order Details (1) | 10271 | Split Rail Beer & Ale | Michael Suyama | 8/1/1996 | 8/29/1996 | 8/30/1996 | $4.54 | Split Rail Beer & Ale |
|
||
|
|
|||||||||||
| Order Details (3) | 10272 | Rattlesnake Canyon Grocery | Michael Suyama | 8/2/1996 | 8/30/1996 | 8/6/1996 | $98.03 | Rattlesnake Canyon Grocery |
|
||
|
|
|||||||||||