|
|
|
 |
 Category |
Product |
Supplier |
QuantityPerUnit |
Stock |
Price |
|---|
| 1 | Beverages | LEO | Exotic Liquids | 10 boxes x 20 bags | 39 | 18.00 |
| 2 | Beverages | Changie | Grandma Kelly's Homestead | 24 - 12 oz bottles | 17 | 0.00 |
| 3 | Condiments | Producto, super | Exotic Liquids | 12 - 550 ml bottles | 13 | 10.12 |
| 4 | Condiments | Chef Anton's Cajun Seasoning | New Orleans Cajun Delights | 48 - 6 oz jars | 53 | 22.00 |
| 5 | Condiments | Chef Anton's Gumbo Mix | New Orleans Cajun Delights | 36 boxes | 0 | 21.35 |
|
|
|
Notes
Show how lookups work. In this case,
- CATEGORYID is a lookup based on select categoryid,categoryname from categories.
- SUPPLIERID is a lookup using select supplierid,companyname from suppliers.
|
|
