Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combine tables (access 2000)

    I have a question regarding combine tables. I have two tables, now i would like to combine them together so that they link and i dont have to go to each different table every time. what would i need to do so that Joe on my table one can have a list under his name. For instance, i would like to be able to add several items from the same catagory under Joe's. My item table has ITEM, CONDITION, LOCATION. So what do i need to do so when i click on Joe i could be able to edit his record. thx

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combine tables (access 2000)

    Use a form based on the table with your names. The table should contain at minimum an ID (AutoNumber field) and the name.
    In this form use a subform based on the item table. Beside the field the table already have add a field of type Number, Long. Name it ID.
    The Main form and the subform have to be linked by the ID field.

    HTH
    Francois

  3. #3
    New Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combine tables (access 2000)

    how can i copy text from tbl1 to tbl2? do i need to turn off the primary key on tbl2?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combine tables (access 2000)

    Maybe I was not clear in my previous post.
    You have in your name table an ID, set to autonumber, and Primary Key. For clarity rename it to IDNames.
    In the Items Table you habe an ID, set to autonumber, and Primary Key. Rename it to IDItems.
    Now Add a field to the items table IDNames, Number, Long.
    The main form and the subform should be linked by IDNames.

    >how can i copy text from tbl1 to tbl2
    Do you mean copy and past or do you want to append records from tbl1 to tbl2 ?
    Francois

Posting Permissions

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