Professional Web Applications Themes

Select from one of three tables based on user input - Microsoft Access

I'm designing a form for our company to use. One of the first selections made is which of the three factories will be the destination point. The next obvious choice is where the will originate from, the origination point. I have a table for each factory listing the different origination points for that factory. I would like to have this selection made based on which factory they chose. Is this possible?...

  1. #1

    Default Select from one of three tables based on user input

    I'm designing a form for our company to use. One of the first selections
    made is which of the three factories will be the destination point. The
    next obvious choice is where the will originate from, the origination point.
    I have a table for
    each factory listing the different origination points for that factory. I
    would like to have this selection made based on which factory they chose.
    Is this possible?


    Alan Guest

  2. #2

    Default Re: Select from one of three tables based on user input

    See:
    Limit content of combo/list boxes
    at:
    http://www.mvps.org/access/forms/frm0028.htm

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html

    "Alan DeHaven" <net> wrote in message
    news:supernews.com... 
    point. 


    Allen Guest

  3. #3

    Default Re: Select from one of three tables based on user input

    Why 3 separate tables? If you had a column for factory, you could select
    from a single table. No?

    --
    Paul Overway
    Logico Solutions, LLC
    www.logico-solutions.com


    "Alan DeHaven" <net> wrote in message
    news:supernews.com... 
    point. 


    Paul Guest

Similar Threads

  1. Device-based or User-based Windows CALs?
    By myMacromediaScreenName in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: August 19th, 04:10 PM
  2. Dynamic generation of list boxes based on user input
    By sage703 in forum Coldfusion Database Access
    Replies: 10
    Last Post: June 25th, 12:43 AM
  3. Insert data into a form based on user input
    By mmflynn in forum Dreamweaver AppDev
    Replies: 0
    Last Post: February 24th, 10:04 PM
  4. Replies: 1
    Last Post: October 23rd, 01:55 AM
  5. Selecting data based on user input
    By Svein Olav Steinmo in forum ASP Database
    Replies: 3
    Last Post: September 23rd, 09:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139