Results 1 to 2 of 2
  1. #1
    phpuser123 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    1

    Post Access 2007 Array issue


    I have a table bus routes and I want to store the different locations a bus travels through for instance from a to b to c ......... in one of its field
    I want to store the bus routes in my tblbus_routes ..


    my tablename: tblbus_routes
    Field : Id , locations

    How can I store the locations in this form in my table.

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Try this arrangement:

    Code:
    tblBusStop
    BusStopID (PK)
    BusStopTitle
    Code:
    tblBusRoute
    BusRouteID (PK)
    BusRouteTitle
    Code:
    tblRouteStop
    RouteStopID (PK)
    BusRouteID
    BusStopID
    Cheers,

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

Similar Threads

  1. Access 2007/Query issue
    By forrestapi in forum Access
    Replies: 8
    Last Post: 11-04-2010, 09:44 AM
  2. Issue with while loop and Access 2007 datasheet
    By jermaine123 in forum Programming
    Replies: 2
    Last Post: 01-17-2010, 10:09 AM
  3. Access 2007: Percent Format Issue
    By diane802 in forum Access
    Replies: 6
    Last Post: 12-30-2009, 10:29 AM
  4. MS Access 2003+Ms Excel 2007 Issue
    By putnum in forum Access
    Replies: 3
    Last Post: 12-20-2009, 09:24 PM
  5. MS Access 2007 - network interruption issue
    By shsh_shah in forum Access
    Replies: 5
    Last Post: 10-11-2009, 09:47 AM

Tags for this Thread

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