Results 1 to 4 of 4
  1. #1
    majddelbany is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    6

    Lightbulb 2 Fields , 1 Value ( ComboBoxes )

    Hello,



    So I am creating a taxi booking system.
    I created a table called " directions ", the fields are " From " " To " and " Price ", then I created a form for it so my users can enter the data.

    My problem started when I created an ordering form, which will include client informations, order details and the directions, I want to create combo boxes to select from " from " and " to " field and I want the " price " box to give the value automatically. Also I want to be able to enter vise versa data, like an example " from : location1 " " to:location2 " and "from:location2" " to: location1".

    Thank you in advance,
    Majd Delbany

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    you cannot have 1 value, you must have:
    tBookRoute table:
    BookID
    FromID
    ToID
    Price
    BookDate


    you can make a function to swap the From/To values.

  3. #3
    majddelbany is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    6
    Oh thanks, I am actually new to access.
    I'll try this out, if possible can you send more details ? As I didn't get it well, so I have to make different tables and then link them with a relation ?

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,563
    Hi

    Can you upload a zipped copy of your Db?

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

Similar Threads

  1. comboboxes on a form
    By ageurtse in forum Forms
    Replies: 9
    Last Post: 05-30-2017, 12:58 PM
  2. ComboBoxes all changing to same value
    By NightWalker in forum Forms
    Replies: 5
    Last Post: 09-22-2016, 09:22 PM
  3. Replies: 3
    Last Post: 03-31-2016, 12:16 PM
  4. Replies: 2
    Last Post: 05-16-2012, 03:10 PM
  5. Comboboxes go where?
    By PaulCW in forum Database Design
    Replies: 12
    Last Post: 10-04-2011, 02:34 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