Place
Tables (4)
Customer (Untitled2)
- Cust (Field) — Primary key
- Cname (Field2)
- Street (Field3)
- City (Field4)
- State (Field5)
- Zip (Field6)
- Phone (Field7)
Invoice (Untitled)
- Invoice (Field5) — Primary key
- ShipVia (Field)
- Terms (Field2)
- Date (Field3)
- TotalOrderAmt (Field4)
- Cust (Field6) — Foreign key → Customer.Cust
LineItem (Untitled3)
- Invoice (Field5) — Foreign key → Invoice.Invoice
- Prod (Field3) — Foreign key → Product.Prod
- SellPrice (Field)
- Quantity (Field2)
Product (Untitled4)
- Prod (Field) — Primary key
- Description (Field2)
- StandardPrice (Field3)