And... each Order may have several Shipments or Boxes.
- I may also have the relationships wrong.
- And the SubForm may be setup wrong.
- In fact it may all be wrong.
How would you guys do this ?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Table Relationships | ||||||||||||||||||
| - At least one thing that is wrong with all this is each item in the tblOrder_Items table has a corrosponding record in tbl_Shipments. What I want is one record in tbl_Shipments for each. A box may contan several Items. And... each Order may have several Shipments or Boxes. - I may also have the relationships wrong. - And the SubForm may be setup wrong. - In fact it may all be wrong. How would you guys do this ? |
||||||||||||||||||
|
||||||||||||||||||
|
||||||||||||||||||
| Orders Form & Order_Items SubForm | ||||||||||||||||||
| Note: Product & Shipper Fields are Combo Boxes | ||||||||||||||||||
|
||||||||||||||||||
| Order Items Query below has all fields from these tables & SubForm above is built on this query | ||||||||||||||||||
|
||||||||||||||||||