Access 2003
Table: Orders
OrderID: Autonumber
ShipState: Long Integer
OrderState: Long Integer
Table: States
StateID: Autonumber
Abbr: Text (2 characters)
Name: Text (full name of state)
Relationships:
ShipState is 1 to many with StateID
OrderState is 1 to many with StateID
Form: Orders...