Two fields in one table relate to one in another

[4ZAq]

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.
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.

 

[marianne]

can you post your db here.

 

[pbaldy]

In a form you could simply have 2 combos, each bound to its respective field in the orders table, both with their rowsources from the states table. In a query, one of the fields would be joined to an alias of the state table.

 

[4ZAq]

Here is the database. Perhaps that will make it clearer.

 

[pbaldy]

What's the problem? If you want to display the full names, change the column widths:

0";0";1.5209"

 

[4ZAq]

Paul,
Somehow I had a hard time understanding how to get here. Your idea worked perfectly. Thank you. No further problem.

 

[pbaldy]

No problemo, and welcome to the site by the way!