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
ShipState: Combobox
OrderState: Combobox
Using form Orders, can select state from dropdown. What shows after the record is saved is the Abbr.
I now want to create a form that shows the two states, but I want to show the state Name rather than abbreviation. Can't seem to make that leap.