Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Question Unanswered: How to combine data from 2 tables into one

    Hi,

    Application: MS Access 2000

    I have two tables.

    Table 1 is named ServerInfo which contains a field called "Servers". The Servers field contains names of servers.

    Table 2 is named NetworkInfo which contains a field called "Device Name". This field contains names of network devices.

    Both Tables 1 and 2 have additional fields which I do not currently care about

    On a form I would like to have a one combo box that would let me display already entered values from Table 1 and 2, possibly storing it to another table

    I am trying to figure this out for days, but I am not getting anywhere. Please help!!

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Assuming you are trying to create a 'network', you would create your third table. Then have a form that looked up the information from table 1 and table 2 and the field should be bound to the third table. When you create your form, the first thing it asks is what data should the form be based on. For the form choose the thord table. Then add the two combo boxes and when the wizard asks you where to store the data, give it then name of the field in the third table.

  3. #3
    Join Date
    Nov 2004
    Posts
    4
    Thank you for your reply, but it is still not workin for me

    Yes, you are correct, I do have a Table 3 that is called "All Devices". - Table 3 should capture the data from Table 1 and 2 in a filed called "All Devices"

    When I try to create a form, the first thing it asks me is "What fields do I want on the Form" - When the wizard is over the only thing it creates is a box for "All_Devices" field

    Only During the "combo box" it asks me "on what data it should be based on"

    Any other suggestions??

    Thanks

  4. #4
    Join Date
    May 2009
    Posts
    4
    LOOK MY FRIEND
    MAKE QUERY
    AND PUT TWO FILED FROM THE TWO TABLES THAT YOU WANT AND IN THE THIRD FILED IN THE QUERY BUT -- Not -REPET: ([SERVER] & "/" & [Device Name])

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The answer is queries.

    You can add fields from any number of tables by using a query. You can then use that query for the record source of a form or to populate combo boxes or list boxes.

    Unless of course I am misunderstanding what you need.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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