Results 1 to 2 of 2
  1. #1
    vj$! is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    1

    Two fields in one table relate to one in another

    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.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Create a query that joins the States table and use it as the RecordfSource of the Orders form. You can display any field of either table on your form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-10-2009, 12:43 PM
  2. Table Fields
    By MFS in forum Access
    Replies: 11
    Last Post: 05-07-2009, 11:12 AM
  3. Replies: 0
    Last Post: 02-24-2009, 12:37 PM
  4. one date entered to hit 3 fields in one table how?
    By techexpressinc in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 10:43 AM
  5. One table multiple fields identical properties.
    By swampdonkey in forum Queries
    Replies: 2
    Last Post: 09-29-2006, 10:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums